on 09-19-2016 8:13 AM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.