Dynamic Table creation with SSIS

• zx10r

  SSC-Addicted

  Points: 410

  More actions

  July 9, 2008 at 7:12 am

  #123083

  Here is what i need to accomplish, i need to extract the first row from a flat file and use its values to create a table with the columns from those extracted values.

  So if the flat files first row has Test1, Test2,Test3

  I need to create a table in the database with columns Test1, Test2,Test3.

  This needs to be dynamic as the number of columns will always be different. Sometimes less sometimes more.

  Any insight on how to do this would be really helpfull.

  Thanks

• Tim Mitchell

  SSCoach

  Points: 15681

  More actions

  July 9, 2008 at 6:31 pm

  #840578

  You'll most likely need to use a script task for this, looping through each file in your directory and processing each file in turn.

  Hope this helps,

  Tim

  Tim Mitchell, Microsoft Data Platform MVP
  Data Warehouse and ETL Consultant
  TimMitchell.net | @Tim_Mitchell | Tyleris.com
  ETL Best Practices