O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Companion by Victor Isakov, Stacia Misner, Burzin Patel, Marcilina Garcia, Edward Whalen

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

Deploying Packages

Once you’ve developed and tested your package, what’s next? You probably don’t want to run the package manually in Visual Studio on a regular basis. In this section, we’ll review package configuration options, deployment and security considerations when moving packages into production, and tasks related to package management after deployment.

Package Configuration

Package configurations allow you to customize how a package runs in different circumstances. For example, when you run the package on a development server, you might want to connect to sample databases for extracting and loading data, but when you run the package on a production server, you want to connect instead to real data sources. You aren’t limited to changing ...

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