how to load dynamic values into a conditional split

• alen teplitsky

  SSC-Dedicated

  Points: 30014

  More actions

  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?

• drew.allen

  SSC Guru

  Points: 77011

  More actions

  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