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 |
|
paull
Yak Posting Veteran
50 Posts |
 Posted - 2010-07-26 : 10:42:39
|
| Hi all. I am very new to using both SQL and SSIS so please bear with my basic question(s)!I have a monthly task of downloading several files from various FTP servers, adding a "type" code (i.e. Country and data type) and loading them into a single SQL table. I pretty much have the basis of my work flow in place - starting with the FTP - File System Task to clean up the directory - Data Flow task including a Derived column or SQL query task - Send mail. All i have to do now is get each element right!!I am at a loss as to how to go about "doing" the FTP task. I have 14 FTP folders, each with a seperate ID and password, that may contain any number (including none) of csv files.What is the best way of doing this task - would it be a ForEach loop, a For loop or just one by one? I have set up a flat file and SQL table with each of the log in account names and passwords in anticipation of using a variable, but got a bit stuck there!Any help or advice would be greatly received!Many thanks |
|
|
|
|
|
FTP task - best method?