Deploying & Deleting a SSIS DTS Package in SQL Server 2005#

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

Deploying a SSIS DTS Package in SQL Server 2005

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....

9/23/2006 11:32:02 PM (India Standard Time, UTC+05:30) #    Comments [3]  |  Trackback

 

All content © 2010, Kiruthik Nandha Kumar
Me !
On this page
This site
Calendar
<September 2010>
SunMonTueWedThuFriSat
2930311234
567891011
12131415161718
19202122232425
262728293012
3456789
Sitemap
Blogroll OPML
Disclaimer

The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.

Send mail to the author(s) E-mail