CODEWITHSUNDEEP
sql-servercsvssisetlflat-file
Naing99
Naing99

Reputation: 9

How to export a Flat File by using SSIS

I want to export a flat file .csv extension from SSIS.

My data is like this: 

Customer Customer Name    Address
AA00     Hla Hla,Ms       Yangon
AA02     Kyaw,U           Taunggyi

I want the flat file to have the below format:

Customer Customer Name    Address
AA00     Hla Hla,Ms       Yangon
AA02     Kyaw,U           Taunggyi

I added OLEDB Source & Flat File Destination in Data Flow. My SQL statement is from OLEDB Source 

SELECT CustCode AS CUSTOMER, Name as Customer Name , Add as Address 
FROM customer

Now, the export looks like the below.

Customer,Customer Name,Address
AA00,Hla Hla,Ms,Yangon
AA02,Kyaw,U,Taunggyi

So, I want to use a stored procedure that , case. There is Execute SQL task in Control Flow. But I don't know how to execute flat file by using that procedure.

Please kindly suggest

Upvotes: 0

Views: 538

Answers (1)

Yahfoufi
Yahfoufi

Reputation: 2544

You can change the column delimiter property from the Flat File connection manager to Tab:

enter image description here

Image reference: http://sqlknowledgebank.blogspot.com/2013/05/ssis-dynamic-flat-file-connection.html

Additional Information about Flat File connection manager

Upvotes: 2

Related Questions