SQL load, error log

desmond botha

Hello All

I get rejected items while loading data from a SQL table.

I have ticked the log file option but I cannot see where the log file is saved (Using BOARD 11 - Cloud)

I looked at the logs on the board cloud administration portal but cannot see anything under SQL logs.

When I load from flat file it generates the log file in the same directory I'm loading from, but I have no idea where the a log file from a SQL load is stored.

 

How can I see which items were rejected during a SQL data reader load?

Many thanks
Desmond

------------------------------
Desmond Botha
Senior Manager
ADAPT IT (PTY) LTD
South Africa
------------------------------

Bettina Clausen

Hi Desmond,

you can find the SQL-Datareader Log in the Cloud Admin Portal under Logs -> Other Logs -> then the technical name (combination of part of the DB name + number) of the Datareader (see also DB-Log for this information).

Hope this helps.

Best regards
Bettina

------------------------------
Bettina Clausen
Consultant
Board
Germany
------------------------------
-------------------------------------------

desmond botha

Thank you very much!  That was exactly what I was looking for.
Much appreciated :-)

------------------------------
Desmond Botha
Senior Manager
ADAPT IT (PTY) LTD
South Africa
------------------------------
-------------------------------------------