Hi
I am importing a csv file with rows like below. This is then being imported into a SQL table. If I pout a text qualifier in of " to make the preview look perfect the package will not run.
If I leave the text qualifier blank then it runs. However it then corrupts the import an puts information into the incorrect columns.
Any ideas how I can solve this please. I need to use " in the text qualifier but then it fails on the flat file source. THanks
1437,06/07/2016 00:00,"Island Mist,Gravel Path",,Name1,,56 Eastcote Road,,Welling,,DA16 2ST,email1.com,,No
1436,06/07/2016 00:00,"Tiki Torch,Spiced Rum",,Name2,,56 Eastcote Road,,Welling,,DA16 2ST,email2,,No
1435,06/07/2016 00:00,Torino Brown,,Name3,The Ashbournes,"High Eggborough Lane, Eggborough",Goole,North Yorkshire,DN14 0PS,email3.com,7885818442,Yes
I am importing a csv file with rows like below. This is then being imported into a SQL table. If I pout a text qualifier in of " to make the preview look perfect the package will not run.
If I leave the text qualifier blank then it runs. However it then corrupts the import an puts information into the incorrect columns.
Any ideas how I can solve this please. I need to use " in the text qualifier but then it fails on the flat file source. THanks
1437,06/07/2016 00:00,"Island Mist,Gravel Path",,Name1,,56 Eastcote Road,,Welling,,DA16 2ST,email1.com,,No
1436,06/07/2016 00:00,"Tiki Torch,Spiced Rum",,Name2,,56 Eastcote Road,,Welling,,DA16 2ST,email2,,No
1435,06/07/2016 00:00,Torino Brown,,Name3,The Ashbournes,"High Eggborough Lane, Eggborough",Goole,North Yorkshire,DN14 0PS,email3.com,7885818442,Yes