Line break is not recognized for header when importing CSV

Anders Bodilsen 26 Reputation points


Trying to my luck here as well.

I have asked the following question on stackoverflow.

All suggestions is happily received.


SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,057 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,486 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Anders Bodilsen 26 Reputation points

    Ended up skipping the header row and mapped the columns manually. Thanks for the suggestion @ZoeHui-MSFT

    1 person found this answer helpful.
    0 comments No comments

  2. ZoeHui-MSFT 34,576 Reputation points

    Hi @Anders Bodilsen,

    Go to Flat File Connection Manager property-->AlwaysCheckForRowDelimiters-->False for a try.

    If this does not work, could you please share the file so that we could do more analysis.


    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments No comments