Loading a pipe delimited file to a Database.

Post any question you may have in regards to GoAnywhere Director and let our talented support staff and other users assist you.
2 posts Page 1 of 1

cshade

Posts: 1
Joined: Mon Mar 01, 2010 1:16 pm

Post by cshade » Mon Mar 01, 2010 1:40 pm
I have a large pipe delimited file that I need to load into a teradata database.
The file is approx 1,000,000 records long and 150 fields wide.
What I would like to do is write any error records to a error log txt file and keep the load running until the end.
Is this possible? If so, what are the steps?
Thank You,
Corey

Support_Duane

Support Specialist
Posts: 65
Joined: Thu Mar 05, 2009 3:49 pm

Post by Support_Duane » Wed Mar 03, 2010 4:40 pm
On a readCSV task, you can set the Skip Invalid Records value (on the advanced tab) to true, and if you have a record that doesn't have the correct number of fields, a record will be written to the error log that will specify which record was in error, how many fields it has and how many it was supposed to have.

Any other error will cause the task to end.
2 posts Page 1 of 1