Friday, September 30, 2011

Deploying Integration Services Packages

You must have noticed that you can deploy Analysis Services and Reporting Services projects to a server using Business Intelligence Development Studio(by right-clicking the project name and selecting Deploy), but there is no such option for deploying Integration Services projects. You can deploy Integration Services packages in one of the following four ways:

1. Using Deployment Utility in Business Intelligence Development Studio

2. Using Import/Export package feature in SQL Server Management Studio

3. Manually deploying the package to the File System.

4. Using the dtutil command line utility.

No comments:

Post a Comment