dts parameters

[fmardani]

Hi,
I would like to pass several parameters to a DTS package and then run the package from a stored procedure in sql server 2000.
How is this done please?

I believe I can use something like this
exec master..xp_cmdshell 'dtsrun /S servername /N dtspackagename /u username /S password'

if the above is correct then how do I pass the parameters to the dts, etc...?

Thanks

 

[tb]

http://www.sqldts.com/?234

thread183-588474

I was standing in the park, wondering why frisbees got bigger as they came closer... then it hit me!