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 |
|
SQLboom
Yak Posting Veteran
63 Posts |
 Posted - 2004-01-21 : 02:07:06
|
| Hi all,Can some DTS task be executed for repeatedly for every row of a table in DTS package. This DTS task is not an SQL task but a collection of some other tasks.E.g., the algorithm could be ..loop cursor's datacall the beginning thread of a set of DTS tasks..end loopThanks.. |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2004-01-21 : 05:14:18
|
| 1....best advice...try to stay away from cursors...performance is (generally) p**s poor.2....investigate a WHILE loop...search here for examples.3....it sounds an inefficient activity you are undertaking....if you supply (much) more info, we may save you a lot of (future) heartache |
 |
|
|
SQLboom
Yak Posting Veteran
63 Posts |
Posted - 2004-01-21 : 05:28:16
|
| i have some records in table and i need to run a DTS package (or say some another task) for each of the rows.. . |
|
|
|
Stoad
Freaky Yak Linguist
1983 Posts |
Posted - 2004-01-21 : 05:57:12
|
| lol Andrew,of course, cursors are poor runners but not to SUCH degree thatthey can be easily OUTperformed by DTS tasks. A cursor is ok forthe subject. |
|
|
|
|
|
|
how to call a task from a loop..