In this chapter, you will learn about:
• SQL Server Integration Services (SSIS)
• Bulk Imports and Exports, including bcp
The pessimist sees the difficulty in every opportunity; the optimist, the opportunity in every difficulty
Many times, we're tasked with getting data from here to there—from one database to another database, or from one server to another server. For the simplest tasks, we have our old friend bcp—the command-line bulk copy program that's been in SQL Server since before SQL Server 7.0.
For more complex tasks, we have SQL Server Integration Services (SSIS), which replaces Data Transformation Services (DTS) from SQL Server 2000. SSIS can be used for extract, transform, and ...