Error on exporting to db2

[RicardoPereira]

Hi,

I'am trying to export data from sql server to db2 but when i execute the package i have always the same error message:

Error at Destination for Row number 1. Errors encountered so far in this task: 1.

Anyone have experience in exporting data from sql server to db2?

Thanks
Ricardo Pereira

 

[JayKusch]

Can you enable the log feature so that we may gleen some more in-depth messages as to why your package is failing.

Thanks

J. Kusch

 

[RicardoPereira]

Here he is:


DATA TRANSFORMATION SERVICES: Data Pump Exception Log


Package Name: aaa
Package Description: DTS package description
Package ID: {E3438594-9889-445C-B228-B035B3AFD4F0}
Package Version: {3790E5A5-1512-4FCB-9F7E-E85F92AA96E6}
Step Name: Copy Data from Results to "RUMBA400"."RPEREIRA"."FILES" Step
Execution Started: 25-08-2003 16:47:31
Error at Destination for Row number 1. Errors encountered so far in this task: 1. 222 |
222|

Execution Completed: 25-08-2003 16:47:31

 

[JayKusch]

Are you using any type of double-byte character set "DBCS"?

Thanks

J. Kusch

 

[plevey]

Try adding DISABLEKEYSETCURSOR=1 to your db2cli.ini file

If fishing was easy it would be called catching