June 22, 2015 at 11:22 pm
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
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply