CODEWITHSUNDEEP
ssis
Dinesh Menon
Dinesh Menon

Reputation: 105

SSIS Error Output

Consider this Transformation

OLE DB Source > 

 Look up Transformation > 

          Match Records > OLE DB Command [Update Statement]
          No Match Records > OLE Destination [Insert]

I wanted to redirect the error rows from both the transformations to the same error log, is there a way to do it?

Regards, Dinesh

Upvotes: 0

Views: 426

Answers (1)

Filip Popović
Filip Popović

Reputation: 2655

You can connect error outputs to the same union all and then write into destination table.

Perhaps You would like to add derived column to make distinction of rows coming from those error outputs. (if there is no any other column that could be used for this purpose)

Upvotes: 1

Related Questions