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 |
|
nord
Posting Yak Master
126 Posts |
 Posted - 2013-04-19 : 10:58:55
|
| Hi,I have ssis take information from the table and grate .csv file,how iI can used ssis put (upload) this file to the ftp.Thanks |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2013-04-19 : 11:25:31
|
| Have you tried the FTP Task in SSIS? |
 |
|
|
nord
Posting Yak Master
126 Posts |
Posted - 2013-04-19 : 11:37:23
|
Yes,but its doesnt work with loop |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2013-04-19 : 12:01:38
|
| If it's placed inside a ForEach container, and you configure the FTP Task IsLocalPathVariable option to True, you can have the ForEach container set the variable for each file it loops over and the task will read it from the variable. |
|
|
|
|
|
|
upload file to ftp