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 |
|
lemondash
Posting Yak Master
159 Posts |
 Posted - 2009-07-20 : 11:25:10
|
| Afternoon all.I am currently putting together a small ssis package that has two differnt data flow tasks but both work in the same way. They both have a ole db connection and the output of teh queries write to a csv file. Is it easy enough for both these files to get uploaded to an ftp site ?The reason i ask is under the ftp task i can only see one option to upload. Would i need to get a for loop componet to put the files in to a varable and then get the ftp componet to read the varable.Any help would be great. |
|
|
rgombina
Constraint Violating Yak Guru
319 Posts |
Posted - 2009-07-22 : 09:35:36
|
| on the RemotePath (FTP Task Editor), provide it with /directory/*.csv |
 |
|
|
|
|
|
Two Data flow tasks and then ftp teh files