May 26, 2008 at 10:28 am
Error: 0xC0202009 at Timeimport, Existing TimeID[7177]: An OLE DB error has occurred. Error code: 0x80040E21.
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E21 Description: "Invalid character value for cast specification".
Error: 0xC020901C at Timeimport, Existing TimeID[7177]: There was an error with input column "TimeID" (10054) on input "OLE DB Command Input" (7182). The column status returned was: "DBSTATUS_UNAVAILABLE".
May 26, 2008 at 4:54 pm
I figured out that the problem is occuering when inserting datetime field into destination table. In my source table i have datetime field as null. How can i handle this error?
I have to import all the records including the null datetime fields.
May 27, 2008 at 12:44 am
Does your destination field allow nulls?
There was a posting not so long ago on if you get blanks, that SQL uses the default (I think something like 1900/01/01).
You need to retain null values at the source and treat them as null values in your data flow
Hope this helps
~PD
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply