I have a flat file source like this.
I've created in SSIS a flat file connection in connection manager with this text qualifier ".
In the preview the data looks fine.
Then I pick the "Bulk Insert Task"-Shape and choose this Data Connection as source. A sql-server table as target.
When I execute this shape the textqulaifier seems not to be recognized and the quotationmarks are imported to the sql server table.
what am I doing wrong?
Thanks for help.