Total Time: 2 hour(s)

Summary: 
This course explains how to move large amounts of data either within a single server or between servers. Bulk Copy Program (BCP) and SQL Server Integration Services (SSIS) are also discussed.

Ojectives: 
After completing this course, students will be able to:
Explain importing and exporting data with SQL Server 2005
Import and export data using the Bulk Copy Program (BCP)
Use OPENROWSET to access any OLE DB data source
Use SSIS to handle the import and export of data
Implement Service Broker
Assemble components into a service

Topics: 
Importing and Exporting Data
Using the Bulk Copy Program
Using OPENROWSET and SSIS
Implementing Service Broker
Assembling Components into a Service

Technical Requirements: 
P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Javascript, DHTML and cookies enabled; Sound card with speakers or headphones strongly recommended.