Flat file with diffrent number of columns

• rnphani

  SSC Rookie

  Points: 48

  More actions

  May 20, 2010 at 12:12 am

  #144917

  i have an existing package which runs like the following

  it has foreach loop which will fetch the files with cvc format 4 colums

  and table maping and insert into database.

  i have problem with 6 coumn of data in flat file how i can handel this with a singel package i need modifi existing package with handling diffrent coluns data with out distrub the existing table mapings

  with error handling any help

  thanks in advance

  pha

• Koen Verbeeck

  SSC Guru

  Points: 259115

  More actions

  May 20, 2010 at 5:18 am

  #1170011

  To be short: you can't do dynamic column mapping with out-of-the-box SSIS. The metadata will always be screwed over.

  The only option is to use script tasks/components to dynamically read/write your data.

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP