Working with Flat files with repetition of columns

• subhashk

  Grasshopper

  Points: 22

  More actions

  July 15, 2012 at 11:52 pm

  #264214

  Hi,

  I have a situation where the flat file consists repetition of data i.e.,

  Name, Address, City, Pincode, Accountno, Accounttype, Accountno, Accountype

  last two rows can be repeated upto 70 times.

  where ID,Name,address,pincode stores in one table and ID, Accountno, AccountType stores in another table.

  And my file contains huge amount of data. So, I trying to build a package.

  So, How to work with repetition of columns in flat file and the flat file is having no delemeter, it is having only fixed width columns.

  Thanks

• S3ssion

  SSChasing Mays

  Points: 602

  More actions

  July 18, 2012 at 6:58 pm

  #1514580

  Not sure I fully understand..

  You have:

  1. A flat file with Column1,Column2,Column3 and no delimeter

  2. You need to split the data as TableA (ID,Column1,Column2) and TableB (ID,Column3)

  | If in Doubt...don't do it!! |

• Koen Verbeeck

  SSC Guru

  Points: 259105

  More actions

  July 18, 2012 at 11:55 pm

  #1514616

  The SSIS flat file source cannot read this if the columns change each time.

  You need to parse this with a script task.

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