Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 error uploading to DB2 table

Author  Topic 

mdhingra01
Posting Yak Master

179 Posts

Posted - 2004-10-15 : 09:01:07
I have a package that loads data into 5 tables in SQL Server. I created an ODBC connection to DB2 and use it to delete and load the data from those 5 tables to a DB2 environment. All ata load okay except for 1 table. The error I get is:

The number of failing rows exceeds ther maximum specified.
[IBM][CLI Driver]CLI0109E String data righttruncation. SQLSTATE=22001.


I though it might have been that one of the columns was set to float, so I changed it to INT, but that didn't seem to make a difference.

Thanks
   

- Advertisement -