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.
| Author |
Topic |
|
maurowp
Starting Member
4 Posts |
 Posted - 2010-10-19 : 09:46:12
|
| 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 0Fail 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 regardsMauro |
|
|
maurowp
Starting Member
4 Posts |
Posted - 2010-10-19 : 09:48:39
|
| sorry, I've posted on the wrong forum!!!! |
 |
|
|
|
|
|
Error handling on a ADO NET Destination