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

Posted by M123geek under Sql Server on 3/26/2016 | Points: 10 | Views : 250 | Status : [Member] | Replies : 1
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 to regain format.
I am using sql server 2012 integration services


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


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 ( ) 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

Login to post response