Deploying & Deleting a SSIS DTS Package in SQL Server 2005
Here we are going to see the steps involved in installing/deploying a SQL Server Integration Services (SSIS) DTS Package.
Deploying a SSIS Package in SQL Server 2005
SQL Server Integration Services Package can be deployed in many ways in SQL Server 2005. The best way is creating a manifest file, and running that.
1. After creating the SQL Server Integration Services (SSIS) DTS Package in Visual Studio 2005 goto the project properties, (by right-clicking the project in the solution explorer, Select : Configuration Properties -> Deployment Utility, in the Right side pane, you have a property named : CreateDeploymentUtility which must be set to True.
2. After that, build the project, and check for a folder called Deployment inside the projects' Bin folder.
3. All the .DTSX file(s) which was used in the project, along with the manifest file (name will be like : <Project Name>.SSISDeploymentManifest ) will be....