March 2007
Beginner to intermediate
88 pages
1h 52m
English
Content preview from SQL Server Integration ServicesBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Deploying Packages
Generally, the best way to deploy a package by building a project deployment utility containing the packages you want to deploy. You then copy the deployment utility to the target server and run the Package Installation Wizard to install the packages to an instance of SQL Server 2005 or to the file system.
A deployment utility is a folder containing files needed to deploy SSIS packages onto a different server. You create the deployment utility on the computer on which the SSIS project is stored. The deployment utility is built using Business Intelligence Development Studio. For more information about the deployment utility, see the topic "How to: Create an Integration Services Package Deployment Utility" in SQL Server Books Online.