Home Forums Data Warehousing Integration Services SSIS 2008 – Read roughly 50 CSV files from a folder, create SQL table from them dynamically, and dump data. RE: SSIS 2008 – Read roughly 50 CSV files from a folder, create SQL table from them dynamically, and dump data.

  • April 19, 2015 at 5:05 am

    #1791862

    This looks like a typical situation for ELT, load everything as a text into the staging area and then do the conversion afterwards.

    😎