Determine how many fields and records in the fixed width file

• adonetok

  SSCrazy Eights

  Points: 8395

  More actions

  August 26, 2010 at 8:37 am

  #237241

  I need to import a big fixed width text data file into SQL server.

  Before importing, how to determine how many fields and records in the file?

• alexmpd

  SSC-Addicted

  Points: 408

  More actions

  August 26, 2010 at 2:33 pm

  #1212554

  You can write clr stored procedure for this