SSIS Text qualifier in Flat File Connection ignored
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.
Microsoft SQL ServerMicrosoft SQL Server 2005
8/22/2022 - Mon
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!