ODBC Reject link to sequential file
Posted: Mon Mar 31, 2008 10:42 pm
My job design is as follows. This is a PX, RCP enabled job.
Sequential File ===> Transformer ==> ODBC Enterprise
||
||
||
\/
Rejects (Seq File)
In one particual file that has 75K records, the data gets loaded but i see a "Fatal" log entry
ODB_AsCollected,0: [DataDirect][ODBC SQL Server Driver]Datetime field overflow
The job did not abort, but the "fatal" log entry clearly appears to be some data that might have been in an out-of-range value or incorrect format.
I wanted to capture the erring record into a reject file and tried to add a link from the ODBC stage to a Seq File or PEEK. Is this valid?
I got the following error "Error: Reject Link 'ODBC_Enterprise_1.DSLink4' is not allowed with the current setting (or lack) of the 'Write Method' property"
I came across one post viewtopic.php?t=96043&highlight=odbc+reject
where ODBC reject link was discussed. I would appreciate your help if you could provide some pointers on how one could get the reject link from ODBC stage.
If this is not allowed from ODBC stage, is there a recommended approach on troubleshooting this?
Thanks in advance for your time and help,
Sequential File ===> Transformer ==> ODBC Enterprise
||
||
||
\/
Rejects (Seq File)
In one particual file that has 75K records, the data gets loaded but i see a "Fatal" log entry
ODB_AsCollected,0: [DataDirect][ODBC SQL Server Driver]Datetime field overflow
The job did not abort, but the "fatal" log entry clearly appears to be some data that might have been in an out-of-range value or incorrect format.
I wanted to capture the erring record into a reject file and tried to add a link from the ODBC stage to a Seq File or PEEK. Is this valid?
I got the following error "Error: Reject Link 'ODBC_Enterprise_1.DSLink4' is not allowed with the current setting (or lack) of the 'Write Method' property"
I came across one post viewtopic.php?t=96043&highlight=odbc+reject
where ODBC reject link was discussed. I would appreciate your help if you could provide some pointers on how one could get the reject link from ODBC stage.
If this is not allowed from ODBC stage, is there a recommended approach on troubleshooting this?
Thanks in advance for your time and help,