CODEWITHSUNDEEP
c#ssis
user5016413
user5016413

Reputation:

Exporting .csv file in ssis with seperated columns

I have ssis package.

And i can successfully export .csv file to local folder. In my package i have db connection and getting columns from stored procedure. But while exporting data to .csv file all columns stands togetger by separated commas.

enter image description here

enter image description here

enter image description here

How can i fix this?

Thanks

Upvotes: 0

Views: 534

Answers (1)

Marko Ivkovic
Marko Ivkovic

Reputation: 1290

If you want to open CSV using excel, use ; for value/column delimiter instead of , for separate value in each column.

And yes, CSV stands for Comma Separated Value, but excel read it as a single value.

I had same issues a few days ago...

Upvotes: 0

Related Questions