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 ...
Get Microsoft® SQL Server™ 2005 Administrator's Companion 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.
