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 |
|
rme8494
Yak Posting Veteran
98 Posts |
 Posted - 2005-02-25 : 12:37:14
|
| Didn't quite know what to search for so I hope I'm not duplicating another post with this question. Issue: I have a DTS package that makes 5 different text files based on 5 different queries from the database using the Data Transformation Task function. What I need to do now is once those 5 files are created I need to FTP them using a command line script I've already developed. My question is how do I insure that the 5 files have been created before I run my FTP step? I thought about the Workflow "on success" option but I don't think it would work properly the way I had it set up because it would FTP after each file was made.So is there a way to do the following..1. Create 5 files2. Then only after the files are made, run FTP step.Thanks.RyanRyan EverhartSBCSBC. Going Beyond the Call! |
|
|
PW
Yak Posting Veteran
95 Posts |
Posted - 2005-02-25 : 13:26:31
|
| You can create multiple "on success" workflows pointing to 1 task. So you'd have 5 "On Success" flows, leaving the 5 transformation tasks and all pointing to the FTP task. The FTP task won't start until all 5 transformations have succeeded. |
 |
|
|
rme8494
Yak Posting Veteran
98 Posts |
Posted - 2005-02-28 : 11:28:10
|
| PW, thank you for the feed back, that was indeed the case. The FTP will not run until the other 5 steps are complete. I was thinking it might run 5 times.Thanks,RyanRyan EverhartSBCSBC. Going Beyond the Call! |
|
|
|
|
|
|
DTS Help