Deploying DTS package in SQL Server 2000
page 1 of 3
Published: 04 May 2009
Unedited - Community Contributed
One of the challenging activities in working with DTS packages in SQL server 2000 is deployment. Hard coding in DTS objects such as connections would appear inevitable and would require changes every time you deploy depending on the environment. Though Enterprise Manager provides extremely good UI to deploy, it is tedious to deploy using it when there are several packages. This article explains the process of removing hard coding with the help of parametrized global variables and also reading configurable values for external resources such as database table or INI file during runtime and a code snip for automated deployment.
by Cyril Beschi
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 19720/ 21

Challenges in deployment of DTS packages

When developing DTS packages, the DTS connection objects and task objects are set with server names (could be DB, FTP, SMTP, etc), credentials, source/target tables, and source/target file path and names in their properties.  This imposes the challenge of changing such hard coded values at the time of deployment of the DTS packages in different environments with environment-specific server names, credentials, etc.  With deployment being an activity of server management group, deployment of such DTS packages becomes impossible without help from development group, though the, server management group does not want to share sensitive information such as server credentials to any other group.  The second challenge of deployment is the manual intervention required in deployment.  Although Enterprise Manager provides an uncomplicated user interface to deploy DTS, it is manual; so it is tedious and error-prone.  This article explains how such hard coded values can be externalized so that changing such values becomes an easy job, and how the deployment of DTS packages can be automated.

View Entire Article

User Comments

No comments posted yet.

Community Advice: ASP | SQL | XML | Regular Expressions | Windows

©Copyright 1998-2024  |  Page Processed at 2024-07-23 5:05:09 PM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search