cancel
Showing results for 
Search instead for 
Did you mean: 

How to find error record

former_member241220
Participant
0 Kudos

Hi All,

I have source file(.txt) having 42 columns, in that one of column "Career Code" having varchar(25) length. But one of the record coming with 27 characters. due to this I am getting value too large error. my question is I have 15000 records, How to check that error record within the stipulated time? I don't want look each and every record.

Thanks

Murali

Accepted Solutions (1)

Accepted Solutions (1)

former_member208402
Active Contributor
0 Kudos

Hi Murali,

In that source flat file--- edit--- you will find error handling in the flat file format options.. there select "Write errors to file to 'YES' and below give location and file name..

Now run the job.. all valid records will load to target and error records will be loaded to that file you gave for error records.

In that file you can see error data.

former_member241220
Participant
0 Kudos

Hi Ravi,

Thanks for your valuable information, is there any alternative way to find error record with out selecting write errors to file option? because I have been working in support project, I could not change anything in job, Just i need to find out the error record and inform to source team to correct that one.

Thanks

Murali

former_member208402
Active Contributor
0 Kudos

Hi Murali,

If you have access to that source file path.... import that file in QA designer and take a flatfile or temp table as target and apply that write error to file logic..

Answers (0)