November 17, 2013 at 7:02 am
I have an external site that gets populated with csv files every Sunday. These files have varied file names depending on creation date and time. I need to import these files into a SQL table using SSIS every Monday for analysis report generation. these file names are in the form of:
bloc_starting_off.Sun_Nov_3_23_44_01_2013.csv
bloc_starting_off.Sun_Nov_10_23_45_01_2013.csv
bloc_starting_off.Sun_Aug_18_23_44_02_2013.csv
Every week I need to pick the latest file and upload it to the database while disregarding files already uploaded. Any idea on how I can go about this using SSIS?
November 17, 2013 at 1:07 pm
This article explains it pretty much:
Introducing the Foreach Loop Container[/url]
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply