Page 1 of 1
Reject load for SQLServer Enterprise Stage
Posted: Tue Feb 05, 2008 10:24 pm
by 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
Re: Reject load for SQLServer Enterprise Stage
Posted: Tue Feb 05, 2008 11:50 pm
by 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,
Re: Reject load for SQLServer Enterprise Stage
Posted: Wed Feb 06, 2008 4:51 pm
by ecclesr
gnreddy wrote:
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
Re: Reject load for SQLServer Enterprise Stage
Posted: Wed Feb 06, 2008 4:55 pm
by ecclesr
gnreddy wrote:
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
Re: Reject load for SQLServer Enterprise Stage
Posted: Thu Feb 14, 2008 4:07 pm
by ecclesr
ecclesr wrote:gnreddy wrote:
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