Error Trapping with the OLE DB Stage
Posted: Tue May 23, 2006 3:02 pm
I'm using the MS OLEDB stage to insert records into SQL Server. I'm finding it lacking in it's abilities to trap errors and reject rows properly. If an error occurs, I'd like for the row and error messages to be sent to a log file. Instead, I see warning messages in the job log and a false completion status of success. Anyone else out there had to deal with a similar issue?
To repeat the experiment:
1. define a column on SQLServer to NOT NULL
2. pass in a NULL value
- or -
1. define a unique constraint
2. try to insert the row
I realize that the examples are something that should be handled in the job itself, but these things can come up. And the failure of this stage to report them is scary
As an aside, the ODBC stage seems to handle the errors fine-n-dandy. But the direction we received a while back from Ascential was to use the OLEDB stage.
Thanks in advance.
To repeat the experiment:
1. define a column on SQLServer to NOT NULL
2. pass in a NULL value
- or -
1. define a unique constraint
2. try to insert the row
I realize that the examples are something that should be handled in the job itself, but these things can come up. And the failure of this stage to report them is scary
![Shocked :shock:](./images/smilies/icon_eek.gif)
As an aside, the ODBC stage seems to handle the errors fine-n-dandy. But the direction we received a while back from Ascential was to use the OLEDB stage.
Thanks in advance.