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 2008 Forums  SSIS and Import/Export (2008)  SSIS package error-Informix to Sql server 2008

Author  Topic  manu2005 Starting Member 1 Post Posted - 2010-02-24 : 17:27:53 Hi Experts, I created a package to import data from Informix and dump into sql server 2008 db table. I am using .net providers\odbc data provider to access informix data and native oledb\sql server native client 10.0 to dump data into sql server db table. My problem is:- informix table contain an invalid date like '2/1/0010' it is invalid in sql server. Please let me know how to handle this situation in SSIS package. At lease we should display a proper message like 'The table contains an invalid date, 2/1/0010, this is not valid in sql server.' Currently i am getting message like 'Error writing to MyDB. Row key: 22362 - Conversion failed because the data value overflowed the type used by the provider.'. Appreciate your help. Manu