export all tables in sql and export in flat file in ssis

  • do you have a examples How to loop through SQL Table from SSIS to get file names and export

    all i wanyt is to export all table from a database in a flat file were the output is the table name with .csv

    can anyone help

    in ssis please

  • One CSV file of one table OR One CSV for all tables? 🙂

    Raunak J

  • sullyf50 (9/23/2011)


    do you have a examples How to loop through SQL Table from SSIS to get file names and export

    all i wanyt is to export all table from a database in a flat file were the output is the table name with .csv

    can anyone help

    in ssis please

    What specifically do you need help with - looping through the tables, or doing the export? There's not much point in one of us giving you a step-by-step guide when there are so many blogs and tutorials available on the web. You should look one of those up and work through it, and post back if there's anything in particular that you don't understand.

    John

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

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