Many times we get this question
"How do we handle parameterized packages using DTS xChange?" Parameterized package means package executed from command line with parameters passed to it. Most common parameters are global variable initial value. Since this is an issue related to command line it has nothing to do with Package migration. When you migrate your SQL Server 2000 Jobs to SQL Server 2005 you might want to review command line changes.
| Parameterized DTS Package - Passing parameters to DTS package from command line |
DTSRun /S "(local)" /N "PkgTest" /A "varFile":"8"="File_001.xls" /E
Note: "8" is DataType ID
|
| Parameterized SSIS Package - Passing parameters to SSIS package from command line |
DTSExec /SQL "\PkgTest" /SERVER "(local)" /SET "\Package.Variables[User::varFile].Value";"File_001.xls"
|
About Nayan Patel
Nayan Patel, MCSD, MCDBA, MCSE is a Product Manager at Pragmatic Works and also Architect/Lead Developer of DTS xChange and SSIS xPress products. He is a consultant, trainer, mentor and developer who is enthusiastic about developing robust BI Tools. He has expertise in many areas of Business Intelligence including Integration Services, Reporting Services, Database Administration, and .Net Software Development. Nayan has created BI and software solutions for Pragmatic Works. He has also worked on several projects related to Windows Applications, Web Applications and BI Applications using Microsoft technologies.
How Big Is Your Package?