Rejected records in Data Reader

Stefan Batalia

Hello all,

where can I show the rejected records in the datareader?

Kind Regards
Stefan Batalia

Dietmar Jeschkeit

Hi Stefan Batalia,

 

if you log the datareader you will have a file for each datareader in ...Board\Dataset\ ! 

 

BR

Dietmar

Alexander Kappes

Dear Stefan Batalia,

 

for SQL DataReaders you can find the Log File depending informations for each rejected record inside your BOARD Server on Board\Dataset folder. The files are ending with log. They consist the first 4 letters of Database name and the datareader number.

 

For ASCII DataReaders the files are placed in the same directory as the source file. It has the same name as the source file with the ending .log

 

Hope it helps

 

regards

 

Alexander Kappes

Stefan Batalia

Hello Alexander,

 

the log files I have found, but where can I find the Data Reader number?

Regards
Stefan Batalia

Alexander Kappes

Dear Stefan Batalia,

 

you can´t directly find the datareader number.

 

Easiest way is to check for the execution of the datareader in your database log file and afterwards see for the log file according the time stamp.

 

Alternatively you can rerun the reader and check for the last changed log file

 

regards

 

Alexander Kappes

Stefan Batalia

Hello all,

 

to run the datareader again is sometimes a problem, when the Action is set to "append".

For datareader with the Action replace it's no problem.

 

Kind Regards
Stefan