Reject load for SQLServer Enterprise Stage

[ecclesr]

I have a simple job outputing to a SqlSever Enterprise stage

What is the best practice for code the job to pickup any rejected rows - as it is not an option to have a reject link from the SQLServer enterpise stage

This problem relates to version 8 of datastage

Thanking you all in advance

[gnreddy]

Hi,

Use LookUp to catch the rejected rows.U take two Target Tables.So that u
can pass matched values to one table and rejected rows to another table.

Regards,

[ecclesr]

Use LookUp to catch the rejected rows.U take two Target Tables.So that u
can pass matched values to one table and rejected rows to another table.

Can you please explain exactly what you mean

Original job would have been

sequential file stage --> Transform stage -> Sql server enterprise stage


Thanking you in advance

[ecclesr]

Use LookUp to catch the rejected rows.U take two Target Tables.So that u
can pass matched values to one table and rejected rows to another table.

Can you please explain exactly what you mean

Original job would have been

sequential file stage --> Transform stage -> Sql server enterprise stage


Thanking you in advance

[ecclesr]

Use LookUp to catch the rejected rows.U take two Target Tables.So that u
can pass matched values to one table and rejected rows to another table.

My SQL Server stage is a target and not a lookup so I do not understand why I would need to include a lookup stage. All I am interested in is capturing the RDBMS rejects and the RDBMS reject codes

My job would have been

sequential file stage --> Transform stage -> Sql server enterprise stage


Thanking you in advance