June 1, 2007 at 3:49 pm
Hi
I am loading a target table(database 1) from source(database 2)
I am getting the following errors.
[OLE DB Destination [1206]] Error: An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Invalid character value for cast specification".
[OLE DB Destination [1206]] Error: There was an error with input column "Expr32" (1317) on input "OLE DB Destination Input" (1219). The column status returned was: "The value could not be converted because of a potential loss of data.".
[OLE DB Destination [1206]] Error: The "input "OLE DB Destination Input" (1219)" failed because error code 0xC0209077 occurred, and the error row disposition on "input "OLE DB Destination Input" (1219)" specifies failure on error. An error occurred on the specified object of the specified component.
The source column is of datatype Char(1) .And the destination column is of a user defined datatype Flag(1) which is a "bit" system datatype.
The same kind of data transfer is happening in 3 other columns in this flow and is perfectly fine.
Please advice.
June 2, 2007 at 2:07 am
hi,
use data converstion transformation between source and target. Since the source is CHAR there could be a chance that invalid data exists i.e. source is having char other than 0 or 1.
Deepak
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply