Working with Flat files with repetition of columns

• subhashk

  SSC Rookie

  Points: 42

  More actions

  July 15, 2012 at 11:56 pm

  #147172

  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

• Rock from VbCity

  Hall of Fame

  Points: 3991

  More actions

  July 16, 2012 at 8:48 am

  #1513125

  Hi SubhashK

  Please take a look at this topic: Problem Importing CSV Files into SQL 2008... It may be the way to do it.

  Cheers,

  Hope this helps,
  Rock from VbCity