Export (0) Print
Expand All
2 out of 2 rated this helpful - Rate this topic

Package Deployment (Integration Services)

SQL Server Integration Services includes tools and wizards that make it simple to deploy packages from the development computer to the production server or to other computers.

NoteNote

To become better acquainted with the concepts explained in this section, see Tutorial: Deploying Packages.

There are four steps in the package deployment process:

  1. The first optional step is optional and involves creating package configurations that update properties of package elements at run time. The configurations are automatically included when you deploy the packages.

  2. The second step is to build the Integration Services project to create a package deployment utility. The deployment utility for the project contains the packages that you want to deploy

  3. The third step is to copy the deployment folder that was created when you built the Integration Services project to the target computer.

  4. The fourth step is to run, on the target computer, the Package Installation Wizard to install the packages to the file system or to an instance of SQL Server.

Package Configurations

Describes package configurations.

Creating Package Configurations

Describes how to create and manage package configurations.

Creating a Deployment Utility

Describes how to build a deployment utility.

Deploying Packages by Using the Deployment Utility

Describes how to install packages by using the deployment utility.

Redeploying Packages

Describes how to redeploy updated packages.

Package Deployment How-to Topics (Integration Services)

Lists the how-to topics used to create and deploy packages.

Tutorial: Deploying Packages

Provides lessons that teach you how to prepare to deploy packages, create a deployment bundle that you use to install packages, and install packages.

Integration Services icon (small) Stay Up to Date with Integration Services

For the latest downloads, articles, samples, and videos from Microsoft, as well as selected solutions from the community, visit the Integration Services page on MSDN or TechNet:

For automatic notification of these updates, subscribe to the RSS feeds available on the page.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.