Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sippon77
Starting Member
13 Posts |
 Posted - 2005-06-09 : 01:44:25
|
| I am executing a DTS package (activex script) through a autosys job using the DTSRun command. This DTS package in turn is calling another DTS package. But i dont want to har code the user id and password in the first package. SO can i pass them as parameters to the first DTS packge which uses them to execute the second DTS package.PS: any approach apart from 'global variable' or reading it from a file or from a table would help.thnx.... |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-06-09 : 06:34:37
|
| What's wrong with global parameters. That's the easiest method as dtsrun allows them to be set. You can then use a dynamic properties task to set them.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Passing Parameters to DTS pkg