I will try the last suggestion of editing the flat file connector and modifying the delimiter and text qualifier settings.
In the meantime, I have a couple of other questions:
1) How do I include the replace/trim sql scripts in the SSIS package? In other words I want to have the SSIS package run the scripts to remove the quotes as part of the package process. Where and how is this done in SSIS?
2) Can a SSIS package be executed from within a SQL script? I would like to use a command button in my application that would run a SQL script or utility that would locate, call and execute the SSIS package. Can this be done and if so, how?
Thanks.