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




Responses

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

Up
0
Down

Resolved
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

Login to post response