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 22, 2015 at 8:47 am

    #1792762

    axissolutionspl (4/22/2015)

    Actually, I followed the excellent blog by Marco Schreuder here: http://blog.in2bi.com/biml/creating-a-meta-data-driven-ssis-solution-with-biml-1-overview/

    Yes there is a bit of learning, but if you just use his example as starting point is not that hard. And you will be rewarded.

    Also note, depending which version of SQL Server you are using, might need to replace the OLEDB provider name on all BIML scripts. His example was for SQL 2008 R2 (SQLNCLI10.1) so I replaced it for SQL 2012 (SQLNCLI11).

    Regards,

    Albert B.

    Excellent. Thanks for the link, Albert.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)