May 23, 2008 at 3:22 pm
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 27, 2008 at 7:13 am
Mike, can you add a little more information here - for example, the transform you are using, the data types, etc.
Tim Mitchell
TimMitchell.net | @tmitch.net | Tyleris.com
ETL Best Practices
May 27, 2008 at 10:09 am
I get this error at the oledb cmd task where I have a update query which updates the EMp table with new and modified rows by cheking for the existing rows. I used the following query
UPDATE personnel.workedhours
SET
JobID(uniqueidentifier,notnull)=?,
LocationID(uniqueidentifier,null)=?,
Date=(datetime,null)?,
JobCategoryID(uniqueidentifier,null)=?,
NoOfHours(money,null)=?,
CaseID(uniqueidentifier,null)=?
WHERE EmpID=?
and the source table is OldEmp which has same datatypes.
Above this task I have a conditional split where in I have ISNULL(EmpID). From this task I have one Update query for Existing records which i already mentioned above and the other is a script component where i generate new EmpID from VB.
Let me know if you need anything else.
May 27, 2008 at 6:33 pm
Mike Levan (5/27/2008)
NoOfHours(money,null)=?,
Mike,
Maybe I'm trying to read too much into this, but you've got a column named NoOfHours (number of hours?) as type of Money. Is that intentional?
Tim Mitchell
TimMitchell.net | @tmitch.net | Tyleris.com
ETL Best Practices
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply