Post reply

same SSIS package reading source files with different names

  • July 15, 2011 at 6:32 am

    #244226

    Hi,

    I am sure this might have ben discussed many times, still I was unable to find the thread.

    Anyways, the requirement is that I need to configure my SSIS package so that it reads the source file name which varies with each day (timestamp appended).

    Source file would be something like this...

    Sourcefile_13072011.csv

    Sourcefile_14072011.csv

    Sourcefile_15072011.csv

    I need to ensure that same package can load these files when they are generated daily.

    Regards,

    Athar Iqbal

  • July 15, 2011 at 6:40 am

    #1353391

    Athar

    You can use an expression to set the connection string for the file connection manager.

    John

  • July 15, 2011 at 6:59 am

    #1353406

    Hi,

    use a Foreach-Container and select the "Foreach File Enumerator".

    With that you are able to loop through the folder and map the diffrent files as filesource (via expression)

    Regards

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply