If this is your first visit, be sure to check out the FAQ by clicking the link above.
You may have to register before you can post: click the register link above to proceed.
To start viewing messages, select the forum that you want to visit from the selection below.
Help using SQL Loader to count the number of fields being loaded
I am loading data into tables using SQL Loader. My datavaires from being comma delimited to simply using whitespace.
The problem is that vendors will often decide to add or remove a column without notification. Is there a way to have the loader check the number of fields then either break if it's incorrect or load the data if it is correct?
Any help you can provide will be greatly appreciated