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.