import fixed width flat file with 500 columns

• dJeePe

  Say Hey Kid

  Points: 712

  More actions

  May 25, 2007 at 10:58 am

  #124162

  I need to import a fixed-width flat file with over 500 columns.

  Is there a way to do this in SSIS without using the "Flat File Connection Manger Editor", which forces me to specify each column one-at-a-time by clicking the ruler over and over in the right spot and then update the properties of each column one-at-a-time.

  Please someone tell me how I can do this in a configuration file where I can cut-and-paste all my column names all-at-once.

  Thanks

• Dave-3000

  SSCertifiable

  Points: 6186

  More actions

  May 25, 2007 at 12:38 pm

  #709070

  Check out Bulk Insert in BOL and on this site.  You can build a format file that links the columns in the flat file with columns in a table.

  There is no "i" in team, but idiot has two.