Updating source XLS with error details

rparam

• July 16, 2008 00:00

• Answered

Follow

I am currently evaluating the tool for an ETL data load exercise. And I am very happy with whatever I have seen so far.

One of the requirement is that I should be able to load data from XLS file and insert into database. This is simple.

But the other part of it is that if the transformation failed for a record due to data type or lookup failure, it should update the source spreadsheet itself with error details.

Can anyone give me a general idea of how the graph should be created to channel the error into source XLS and write the error details in its own column on the same row as that of data.

Thanks,
Param.

• 

  avackova

  • July 17, 2008 06:54

  0

  Comment actions Permalink

  It is not possible. You can only join rejected records from DBOutputTable with the original records (with left outer join) and then save them again in xls file.

Please sign in to leave a comment.