Sql Server Integrated Services Package Deployment

SQL 2005: SQL Server Integration Services Package Deployment

Introduction

A decent amount of material has been covered in this introductory series on SQL Server 2005 Integration Services. Many of the basic data flow tasks have been covered along with some database maintenance tasks. It is now time to put these techniques into use.

Scenario

The package development is now complete and it is time to move the package into a working environment whether it is a testing environment or a production environment. Using some file configurations settings and SQL Management Studio, the developed packages will be deployed to a SQL server.

Implementation

If you have worked all the way through the series, you will have several packages to import. All though they each build on top of one another, this will give a good example on how to deploy several packages that are under the same SSIS project. So the first issue is how SQL server finds dtsx files. There are numerous ways but one that I prefer is to add some settings to the integration services configuration file to tell SQL server where to look for dtsx packages. Go ahead and open up Windows Explorer and navigate to C:Program FilesMicrosoft SQL Server90DTSBin.

Then open up MsDtsSrvr.ini in your favorite text editor add a meaningful name denoting the types of packages are contained in the folder and also add the physical folder path to where the dtsx files are located. For this example, Dev is the name and C:SSIS is the folder path of where the files are stored. The completed changes should look like the highlighted area in the following screen shot.

Please Visit Programminghelp.com For the full article and pictorial tutorial.

http://www.programminghelp.com/database/sqlserver/sql-server-integrated-services-package-deployment/