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 |
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
 Posted - 2007-12-18 : 11:08:40
|
| Hi i have a FTP task on my SSIS package where i want to select 3 files from a directory, this directory already contains other files but i only want 3 of them how do i only pull down the 3 files from the FTP site i can't seem to find a option on the FTP task to select what files i want from the direcroty. |
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2007-12-18 : 13:41:38
|
| Option 1) Sequence Container with multiple (3) FTP Tasks inside of it.Option 2) Write a custom script.What are the filenames? Do these 3 files follow a pattern? |
 |
|
|
zeusws6
Starting Member
1 Post |
Posted - 2007-12-19 : 17:12:33
|
| I'm working on the same problem. I'm trying to pull down multiple different files (orders) from an FTP site. Their names follow a pattern 850*.txt, but I'm wondering how to pull back and manage the filenames so I can go back and delete them later after they've been downloaded. Any suggestions?Thanks!Chris |
|
|
|
rgombina
Constraint Violating Yak Guru
319 Posts |
Posted - 2008-01-16 : 09:54:37
|
| Solution #1:Store data (filenames) in a table. Use SQL Task to cycle rows and save each row into an Object. Use "Foreach ADO Enumerator" and drop FTP task within Foreach container.Solution #2:Store data (filenames) in an ArrayList and save each row into an Object. Use "Foreach From Variable Enumerator" to evaluate each filename and drop FTP task within Foreach container.Good luck! |
|
|
|
|
|
|
FTP Task for multiple files