|
David Lundell, MBA Principal Consultant & Trainer |
|
Making DTS and SSIS Packages Portable |
|
Abstract: One of the most significant challenges to using DTS effectively is in migrating DTS packages between dev and test, and test and production without opening the packages and modifying connection strings and other configuration items particular to each server. The main focus of this article is to show you how to make migrating/promoting DTS packages and SSIS packages from dev to test to production seamless and easy. You will see demos showing how to make DTS packages portable using Dynamic properties, Active X Script tasks, Global Variables and DTSrun command line parameters. You will see a demonstration of how this issue is solved in SQL 2005 with SSIS package configurations.
A further thorn in one's side has to do with DTS logs being distinctly unfriendly; you will see a demonstration of how to make your DTS logs a lot easier on the eyes. Lastly you will see a demo on how SSIS logging is done and its plethora of options. |
|
This article is based on a presentation David Lundell made to the Arizona SQL Server Users Group in Feb. 2006.
Making DTS and SSIS Packages Portable — Presentation with Screen Shots
Making DTS and SSIS Packages Portable Part1 DTS.pdf
Code from Article: DTS ActiveX Logging Script.txt
|