Hi
Is it possible to give a reject link to DRS stage while doing truncate and insert,so that all the records not inserted goes to a sequential file .
Thanks for help
Arif
Rejects in DRS
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Charter Member
- Posts: 87
- Joined: Sat Mar 18, 2006 11:45 pm
I doesnt accept any reject links ,even the ODBC enterprise stage with the property truncate and write doesnt supports reject links.ray.wurlod wrote:Have you even tried to create a Rejects link? Let us know the result.
Is there a way to capture records that are not inserted in databse to a sequential file .
Thanks
ARif
The funny thing is that the documentation says that you can have a reject link and even while creating a link from the DSR one gets a error that non-reject links are not supported by the source stage. ![Confused :?](./images/smilies/icon_confused.gif)
![Confused :?](./images/smilies/icon_confused.gif)
It took me fifteen years to discover I had no talent for ETL, but I couldn't give it up because by that time I was too famous.