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 |
|
pelegk2
Aged Yak Warrior
723 Posts |
 Posted - 2007-09-17 : 16:13:49
|
| 1)can i in a job check a certin condition and if its true then to activate DTS1 (and passing it some variables)else activate DTS2 (and passing it some variables)2)can i activate the same job more then once at the same time (from diffrent jobs for examle?thnaks in advancepelegIsrael -the best place to live in aftr heaven 9but no one wan't to go there so fast -:) |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-18 : 23:40:52
|
| 1. possible, you can call dts package with dtsrun.2. depends on what the job does. |
 |
|
|
pelegk2
Aged Yak Warrior
723 Posts |
Posted - 2007-09-19 : 03:52:54
|
| 2) i want to pass to the dts a value which tells him with which table to wrok (i have some tempTable(i=1..5) and i have 5 jobseach job will call this same DTs but with id of 1..5, which means a tds will run an access only to a certin table at a time (so the dts will run in the 5 instances each working width a diffrent table)can i pass a value to the dts from the job?thnaks in advanepelegIsrael -the best place to live in aftr heaven 9but no one wan't to go there so fast -:) |
|
|
|
cat_jesus
Aged Yak Warrior
547 Posts |
Posted - 2007-09-19 : 16:38:00
|
| You can set up a global variable in the DTS package(s) and set the variable when you invoke DTSRUN in the job. Use the /A parameter to set the variable at run time. Look up DTSRUN in books online for more detailed information. |
|
|
|
|
|
|
job and dts