Populating a SSIS date variable from an Excel date.
Posted on 2006-06-15
I'm getting an SSIS error ([Execute SQL Task] Error: An error occurred while assigning a value to variable "StartDate": "Unsupported data type on result set binding Start Date.".) when I try to read an Excel date into an SSIS variable. The Excel cell is formatted as a date field as is the SSIS variable. I can import the date (from Excel) into a SQL table with no problems but when I try to get it into the SSIS variable I get the error.
Any help would be appreciated!
Thanks in advance,