Lesson 11

This module disucssed how to load and export data a number of different ways in SQL Server
By now, you should be able to:

1. Load data with the insert statement
2. Load data with the select into statement
3. Use the bulk insert statement
4. Use the bcp program
5. Identify key features of Data Transformation Services
6. Use DTS Designer to create a package.
7. Create, schedule, and run DTS packages
8. Identify key features of DTS Wizard
9. Run the DTS Wizard

The following terms were introduced to you in this module:

1. COM: Component Object Model is a model for APIs used to access data.
2. Compute by: A TSQL extension that allows you to have summary rows intermixed with detail rows.
3. Collation sequence: Determines the order in which unicode data is sorted.
4. (DTS):Data transformation service A SQL Server component that allows you to transfer data between multiple data sources.
5. Derived columns: A calculated column. SQL Server allows you to define derived columns as part of the table definition.
6. Identity column: An automatically incrementing column.
7. Microsoft Repository: A set of Microsoft ActiveX interfaces and data models that are used to define database schema and data transformations as specified by the Microsoft Data Warehousing Framework.
8. msdb: The system database that is used to store SQL Server Agent information and DTS information.
9. Package: A set of DTS commands used to transform data
10. SQL Server Agent: A SQL Sever component that allows you to schedule jobs, define alerts, and define operators.
11. Task: One of the steps in a job.
12. Workflow: Describes the steps need top be done to complete a task.

The next module will show you how to monitor SQL Server using SQL and SQL-EM.

Click the Quiz link below to see how well you've mastered the concepts in this module.
Load SQL Data - Quiz