Search code examples
sqlcsvssisetl

SSIS load to CSV puts everything in Column A

I have seen multiple topics about related issues, but no solution yet.

I am using SSIS to load data from a query into a CSV file. When I configure the package and click preview, everything looks fine, but when opening the CSV file, the four separate values are in one column and not in 4 separate columns with headers.

This is my preview in the Flat File destination (which looks fine): [preview destination]1

This is the configuration of the flat file connection: [configuration flat file connection]2

This is the preview from the connection manager: [connection manager]3

But this is how the results looks like:

[result all in 1 column]4

Is there anyone who knows how to fix this?

Thanks in advance. Best regards, Mike

Solution

  • 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 yesterday...