August 26, 2007 at 8:02 pm
Hi,
Trying to convert data from MS Access to SQl server 2005.
I get the following eror when copying a column that contains a time in a string format eg 11:55
From MS Access I use CStr(Format([TBL_HISTORY].[Time],'Short Time'))
Can anyone advise what to do in this situation?
TITLE: Package Validation Error
------------------------------
Package Validation Error
------------------------------
ADDITIONAL INFORMATION:
Error at Data Flow Task [OLE DB Destination [1907]]: Column "CLINIC_TIME" cannot convert between unicode and non-unicode string data types.
Error at Data Flow Task [DTS.Pipeline]: "component "OLE DB Destination" (1907)" failed validation and returned validation status "VS_ISBROKEN".
Error at Data Flow Task [DTS.Pipeline]: One or more component failed validation.
Error at Data Flow Task: There were errors during task validation.
(Microsoft.DataTransformationServices.VsIntegration)
------------------------------
BUTTONS:
OK
------------------------------
August 27, 2007 at 1:47 pm
You may need to add a data conversion task inbetween your source and destination to explicitly convert the values.
SSIS doesn't like to do implicit unicode to non-unicode data types. (It also defaults most inputs to unicode.)
Hope this helps,
Dan
August 27, 2007 at 6:35 pm
Hi,
I combined date and time together : Format([Date] & ' ' & [tbl_history].[Time],'dd-mmm-yyyy hh:nn')
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply