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.

Loading a pipe delimited file to a Database.

Postby 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
cshade
 
Posts: 1
Joined: Mon Mar 01, 2010 1:16 pm

Re: Loading a pipe delimited file to a Database.

Postby 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.
Support_Duane
Support Specialist
 
Posts: 65
Joined: Thu Mar 05, 2009 3:49 pm


Return to Community Forum

Who is online

Users browsing this forum: Yahoo [Bot] and 3 guests

cron