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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-05-02 : 10:46:31
|
| icantspell writes "I've written DTS package that produces a text file form a database. The text file has data in it relivant to an active X script that sets up global variables the data transform uses to produce the text file. If the data fllow looks like:start -> it time to run?-> set up variables -> make fileI now need to do this for all records in another data base. the new follow looks like:start->get lastest id->time to run?->make fileif its not time to run the work flow (on failure) points back to get latest id.When i run the package nothing happens. (ie it doesn't loop through)any reason for this." |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-05-02 : 13:31:38
|
| DTS packages are not normally designed to loop like this. If the test for "time to run" is really a time or date test, then a better way would be to put this in a Scheduled JOB and let the scheduler handle when it is time to run. Your job can then call a DTS package if one is necessary to create the file. |
 |
|
|
|
|
|
DTS