Post reply

Need to import data from ANY .csv file in a folder....

  • February 25, 2014 at 7:21 am

    #288644

    ...I can see how to import a named csv, but the file will be dropped in as needed...

    Anyone know what task(s) will do the job?

    Thanks

  • February 25, 2014 at 7:32 am

    #1691875

    Use the Foreach Loop Container to find all the *.csv files in the folder. Use an expression on the file connection manager to assign the actual file name. For easy of coding, etc, make sure the file is dropped into a folder that does not have files for other packages.

  • March 4, 2014 at 10:08 am

    #1693974

    EricEyster (2/25/2014)

    Use the Foreach Loop Container to find all the *.csv files in the folder. Use an expression on the file connection manager to assign the actual file name. For easy of coding, etc, make sure the file is dropped into a folder that does not have files for other packages.

    That worked a treat, thanks Eric.

    🙂

    JS

  • March 4, 2014 at 11:17 am

    #1694000

    Awesome. Glad I could help and thanks for marking it as solved.

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

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