Post reply

how to load dynamic values into a conditional split

  • August 15, 2011 at 7:12 am

    #241768

    i have a 500 row table that i need to periodically dump to csv or excel format. the only gotcha is that i need to dump it into 10 separate files. there is a batch number column with approximately 10 unique values in the table and i need to create a separate file for each one.

    i mostly work on the db engine side, can someone point me to some examples on how to do it?

  • August 15, 2011 at 8:23 am

    #1368632

    Here is a good example of dynamically changing the connection string to a server connection using the foreach ADO enumerator. It can easily be adapted to dynamically set the connection string for a flat file connection.

    http://www.codeproject.com/KB/database/foreachadossis.aspx

    Drew

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

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

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