December 1, 2008 at 7:24 pm
I am trying to load data from Excel. Certain columns can have numeric and alpha numeric data (EG: ORder Number could be "1233" or "ABC-123"). The destination is of varchar data type. When I run the SSIS if the data in the first row for the column is alpha numeric ("ABC-123") the SSIS loads both the alpha numeric and numeric data. But if the first row is numeric then it ignores alpha numeric (loads NULL instead of alpha numeric).
How can we fix that?
Thanks
Sreejith
December 1, 2008 at 7:35 pm
This is a common complaint with Excel input data. Check out this thread for some further details and ideas:
http://www.sqlservercentral.com/Forums/Topic423760-148-1.aspx
Phil
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply