sql server dts: Hi All,

I'd like to create a parameterized DTS package on SQL Server 2000. Is it
possible to call it from command prompt or an application with parameters? If
so, what is the correct way?

Many thanks.

[quoted text, click to view]

You can execute the DTSRUN command-line utility and pass package variable
values using /A parameters. For example:

DTSRun /S MyServer /N MyPackage /A MyStringVariable1:8="my value 1" /A
MyIntegerVariable1:3="0"

See the Books Online for DTSRUN details. You can also set variable values
in application code before executing a package.

--
Hope this helps.

Dan Guzman
SQL Server MVP

[quoted text, click to view]