Anyone importing Sams.gov Data

• GF

  Hall of Fame

  Points: 3774

  More actions

  June 22, 2015 at 11:22 pm

  #309390

  We have been importing data supplied by Sams.gov for several years.

  At the beginning of this year, 2015, they changed their format and now one has a choice of ASCII or UTF-8

  In the past I have used the import wizard in SQL 2008 R2 to simply import the ASCII file without problems.

  For some reason now, the import wizard reads every source column as a varchar(50).

  In reality, there are some columns that should be varchar(2000) and and some that should be varchar(10).

  The problem I am having is no matter how I change the source column in the import wizard the import fails with either a truncation error, or a data type mismatch. I change the columns to match what the error is reporting and still no success.

  SSIS is not my strong suit so I would appreciate any help on this.

  Thanks

  Gary