January 2, 2011 at 6:45 pm
SSIS 2008 is assigning a "date" data type for several columns in the source excel file and mapping it to "date time stamp" data type in the destination SQL Server columns.
I reset the column data types in excel to 'general' and rebuilt SSIS package, but same problem, and as a result, package won't run.
Please help.
January 3, 2011 at 3:35 am
How do you want to import the Excel columns?
As strings or as dates?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 3, 2011 at 4:00 am
hxkresl (1/2/2011)
SSIS 2008 is assigning a "date" data type for several columns in the source excel file and mapping it to "date time stamp" data type in the destination SQL Server columns.I reset the column data types in excel to 'general' and rebuilt SSIS package, but same problem, and as a result, package won't run.
Please help.
I believe that all you changed in Excel were display formats, not datatypes, which Excel does not really support (beyond 'text' or 'numeric'). The changes you need to make are within the design of the SSIS package itself.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply