SSIS projects with double or even triple quotation marks
I have several SSIS projects that have run for a while with no issues. They read a csv file and insert data into SQL tables. Recently I have noticed lost records. Digging into the issue I see the users have started putting quotation marks within quotation marks. For example: "The Rain in Spain stays mainly in the plains" has become "The rain in Spain stays mainly in the "plains"". What is the best way to handle this? Do I eliminate all quotation marks?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Please outline the steps you are taking to accomplish this task?
ASKER
I have a small SSIS PROJECT. Control flow starts with a task that truncates the destination table. The second task consists of a data flow task that reads the csv file and then writes to the destination via an OLEDB destination. The columns are mapped to match between the csv file and the SQL table. I did just discovered that the text qualifier was NOT set to double quotation marks. I have changed this and the job will run again as scheduled at 7am tomorrow. I will know then if that was the problem. This is one of 10 SSIS jobs which are all set the same way. This one somehow was incorrectly setup.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
The problem was not keeping proper track of all my projects and when they were deployed. It appears I had, for this project, updated it but never deployed it. What a maroon! Thanks for everyone's time and suggestions.
ASKER
Thanks
ASKER