O'Reilly logo

Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008 by Kevin S. Goff Lynn Langit Davide Mauri, Sahil Malik, and John C. Welch

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

The Deployment Challenge

After you’ve developed, debugged, and tested your ETL SSIS packages, you will want to deploy your packages to production or to preproduction servers—the latter if your project is being implemented in a more complex (enterprise) environment.

Note

Note

If you used SQL Server 2000 Data Transformation Services (DTS), SQL Server 2008 SSIS deployment will be a new process for you. With SQL Server 2000 DTS, packages were usually created on the same server where they would be executed, thus eliminating the need to deploy them. Of course, you might have used a server for development and another server for production and therefore had to ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required