SSIS Data Import

  • 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?

  • 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