How to determine the line no from an input file?

How-to(s), solutions to common problems, pearls of wisdom

avackova
Posts: 841
Joined: Fri Jul 20, 2007 9:28 am

How to determine the line no from an input file?

Postby avackova » Wed May 05, 2010 9:57 am

Scenario:
An input file is read from DataReader component , move to couple of Reformat component and finally updates the table using DBoutputTable component.

The problem:
We are able to log the incorrect records but not able to find the line no of the error record from the input file . We need to log the line no in the error log file.
Agata Vackova
Javlin a.s.
agata.vackova@javlin.eu

avackova
Posts: 841
Joined: Fri Jul 20, 2007 9:28 am

Re: How to determine the line no from an input file?

Postby avackova » Wed May 05, 2010 10:00 am

The aim can be achieved by usage of auto_filling feature. Just add one more field to your metadata, that will be fulfilled with global row count value or source row count value.
Agata Vackova

Javlin a.s.

agata.vackova@javlin.eu


cron