Chapter 11. Creating Packages and Transferring Data
Packages allow you to control not only the transfer of data in and out of the SQL Server 2005 server (commonly referred to as extraction, transformation, and loading, or ETL for short), but also to automate a variety of maintenance and administrative functions. This can all be done through a graphical development environment that provides debugging and troubleshooting support.
The types of tasks you are likely to want to automate include the following:
- Transfer data
- Maintain databases
- Run commands
The packages model gives you access to intensive script-like control and power, but in an easy-to-use and modular interface. Similar capabilities exist in scripting, batch files, or programming languages ...
Get Microsoft® SQL Server 2005 Management and Administration now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
