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)  Error handling on a ADO NET Destination

Author  Topic  maurowp Starting Member 4 Posts Posted - 2010-10-19 : 09:47:57 Hi! I have a Data Flow Task on Visual Studio 2008. In this Task, I have a data written in a ADO NET Destination. In it, I have set 'Redirect row' in case of Error handling. So, I have put a script component destination where I wrote error data in a table. But: I have only ErrorCode and ErrorColumn fields for error info? It seems that I have a detailed error in case of 'Fail component' in the ADO NET destination and only two numbers (and ErrorColumn is always 0) in case of 'Redirect row'? Redirect row error data: ErrorCode ErrorColumn -1071610801 0 Fail component error data: Error: 0xC020844B at Data Flow Task, ADO NET Destination [545]: An exception has occurred during data insertion, the message returned from the provider is: ORA-01400: cannot insert NULL into ("ORA_USER"."OUTPUT_TABLE"."NAME") Am I wrong? there are some way to handle the 'Redirect row' with the same detailed description of 'Fail component'? Some missing fields or variables? thanks for the help!!!! Best regards Mauro