Author |
Topic |
ANair
Starting Member
7 Posts |
Posted - 2008-07-18 : 14:06:27
|
I need to transfer data from a table in SQL Server to a file in AS 400 server. I am using the provider Microsoft OLE DB provider for DB2. When trying to execute the package I am getting the following error message: [OLE DB Destination [3643]] Error: An OLE DB error has occurred. Error code: 0x80040E21. An OLE DB record is available. Source: "Microsoft DB2 OLE DB Provider" Hresult: 0x80040E14 Description: "Character in CAST argument not valid. SQLSTATE: 22018, SQLCODE: -420". [OLE DB Destination [3643]] Error: The "input "OLE DB Destination Input" (3656)" failed because error code 0xC020907B occurred, and the error row disposition on "input "OLE DB Destination Input" (3656)" specifies failure on error. An error occurred on the specified object of the specified component. [DTS.Pipeline] Error: The ProcessInput method on component "OLE DB Destination" (3643) failed with error code 0xC0209029. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. [DTS.Pipeline] Error: Thread "WorkThread0" has exited with error code 0xC0209029. Initially I thought like this is a casting issue. But I tried transferring data from one column. Then also I am getting the same error. The package gets failed in OLE DB Destination. It succesfully executes in OLE DB source. Expecting a reply on this. |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-18 : 14:15:59
|
do you have any invalid characters coming from table? also it would be good if you can compare the types of columns from source and that in the destination metadata to see any incompatibilities. |
 |
|
ANair
Starting Member
7 Posts |
Posted - 2008-07-19 : 01:35:17
|
Visakh,I dont have any invalid characters coming from a table. After getting this error, I tried to execute the package with one column alone. Then also I am getting the same error.Using where clause I limited the data from source table to fetch only 10 rows.The column is of data type string of max length 17.Expecting a reply ASAP |
 |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-19 : 01:57:12
|
quote: Originally posted by ANair Visakh,I dont have any invalid characters coming from a table. After getting this error, I tried to execute the package with one column alone. Then also I am getting the same error.Using where clause I limited the data from source table to fetch only 10 rows.The column is of data type string of max length 17.Expecting a reply ASAP
as suggested did you compare the data types of columns coming from source path to the ones in destination to spot out any differences? |
 |
|
ANair
Starting Member
7 Posts |
Posted - 2008-07-19 : 02:18:24
|
Vishakh,Both are of type string. There exists no differences between them.Your help is highly appreciated. |
 |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-19 : 02:33:02
|
quote: Originally posted by ANair Vishakh,Both are of type string. There exists no differences between them.Your help is highly appreciated.
but seeing the error i certainly feel there is casting happening either explicitly by giving cast (which you told you're not doing) or implicitly due to changes in datatypes of source and destination columns(this is what i suspect) and it seems like field value is having some character which causes error in implicit casting.Also ,to confirm ,is there any derived column task in between which introduces any new field in flow which is not present in source? |
 |
|
ANair
Starting Member
7 Posts |
Posted - 2008-07-20 : 07:36:26
|
Vishakh,Could you please let me know how to check that? I am new to SSIS.Your help is highly appreciated. |
 |
|
ANair
Starting Member
7 Posts |
Posted - 2008-07-21 : 01:55:43
|
Vishakh, Can i have your chat id (hotmail) please? |
 |
|
ANair
Starting Member
7 Posts |
Posted - 2008-07-21 : 05:10:06
|
Vishakh, Need your help badly.. |
 |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-21 : 06:33:31
|
quote: Originally posted by ANair Vishakh, Need your help badly..
goto the metatdata tab of line that joins to destination step and check if types of columns are same as in destination.b/w i dont have hotmailid. my gmailid is visakh16@gmail.com |
 |
|
ANair
Starting Member
7 Posts |
Posted - 2008-07-21 : 07:07:47
|
Vishakh, I have added you...waiting for you to accept in gtalk. |
 |
|
|