dorothy.burton (10/17/2013)
I am familiar with SSIS, but not sure of how to get this task done.
Depends on how you want to download the file.
Could be with the FTP task, or with some .NET. (Downloading a file over HTTP the SSIS way)
Extracting could be done with an Execute Process Task (or with some .NET if you want to).
Importing the .csv files can be done with a data flow inside a for each loop.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP