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 |
|
Roge
Starting Member
2 Posts |
 Posted - 2012-06-08 : 10:10:27
|
| Hello...I'm not familiar, but I have to modify the existing DTS.(SQL 2000)I'm trying to do "on success" between one connection & "task" (execute SQL task), but it fails . error "defining precedences between the selected items is not valid"But that package has similar work flow. Any idead how to fix this?Thanks |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2012-06-08 : 11:36:34
|
| Connection to task? Is it a source connection? Needs to be a destination so that the dependancy is on the completion of the task (for the start of the dependancy).My memory of how dts presents in the gui could be wrong tough.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-06-08 : 11:50:50
|
quote:
Originally posted by Roge
Hello...I'm not familiar, but I have to modify the existing DTS.(SQL 2000)I'm trying to do "on success" between one connection & "task" (execute SQL task), but it fails . error "defining precedences between the selected items is not valid"But that package has similar work flow. Any idead how to fix this?Thanks
what are those tasks?Are they part same control flow? or are they in separate flow whose execution is determined by global variable value?In any case we need more details on package to suggest anything------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
Roge
Starting Member
2 Posts |
Posted - 2012-06-08 : 12:57:56
|
| Thanks guys..Some how I managed to do it. I think I missed the order.Now it is fine :) |
|
|
|
|
|
|
DTS