• Gosh I know that's gonna be hard. I thought you just wanted SSIS error code. Well, to do that, you have to customize some codes in the script component according to what you know the error would be. Let's say you have datatype mismatch, you will have to point that to the column in the script component itself. For this, again, you would need .NET program to help you.

    Or, let say you want to just separate null values where it should not be null, you can do this in conditional split. The code should be something like this:

    ISNULL(ColumnName1)&&ISNULL(ColumnName2) and so on......

    Name this as NULLS

    So you will have this error generated by conditional split. Then point this to a separate destination of your choice, lets say a table or flatfile. When you drag an arrow(green one), the one you named NULLS just now will now appear. take that to the destination. Now, this destination will have only nulls and the column names will also be there as you wished.

    The negative side of doing this in a conditional split is that if you have 50 errors to generate, you will have to do it for 50 of them each. That can be frustrating and not professional. Otherwise, if you know the errors that you are about to predict and they are just about 4 or 5, then you can use this approach. But, the best is always by coding it into a script using any .NET codes.

    Hope I help you a little here.........

    [font="Verdana"]Imagination is more important than knowledge-Albert Einstein[/font]