Issues importing data from SQL Server to Vertica using Toad Data Point
I am trying to import a table from SQL Server into Vertica using Toad Data Point. Most of the data loaded but I have several rejected rows. I assume the rows are rejected because of comma delimited lists. Our data has the following delimeters in some of the data... comma, pipe, colon, semicolon, etc. So this import is becoming difficult.
It is my understanding that when you import data into Vertica, Vertica translates the data into a CSV file and then loads the CSV. We are eventually going to use Informatica to import the data, but as of now all I have is Toda DP.
Steps: Used Import/Export wizard from Toad to load data from a query. As I said, most of the data loads properly with the exception of data that has commas.
Any help would be appreciated. Please let me know if I am being clear enough about this topic.