format help required for SSIS loading file format is csv [Resolved]

Posted by M123geek under Sql Server on 3/26/2016 | Points: 10 | Views : 1250 | Status : [Member] | Replies : 1

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

i am trying to upload excel, but there were some issues so changed to CSV.Now when i connect to csv file and see the preview in connection manager the format is changed.how to regain format.
I am using sql server 2012 integration services

Attachment

[Resolved]

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Rajnilari2015 on: 3/27/2016 [Member] [Microsoft_MVP] [MVP] Platinum | Points: 50

0	Some things that you must check a) Select Flat File Source among Data Flow Sources b) In Flat -File Connection Manager window, select Format as Delimited c) Set the header row delimiter as {CR}{LF} Please read this article ( http://www.kodyaz.com/articles/import-csv-flat-file-into-sql-server-using-ssis-integration-services.aspx ) for a step by step process of the same. Hope that helps -- Thanks & Regards, RNA Team M123geek, if this helps please login to Mark As Answer. \| Alert Moderator

Some things that you must check

a) Select Flat File Source among Data Flow Sources
b) In Flat -File Connection Manager window, select Format as Delimited
c) Set the header row delimiter as {CR}{LF}

Please read this article ( http://www.kodyaz.com/articles/import-csv-flat-file-into-sql-server-using-ssis-integration-services.aspx ) for a step by step process of the same.

Hope that helps

--
Thanks & Regards,
RNA Team

M123geek, if this helps please login to Mark As Answer. | Alert Moderator

Latest Posts