Line break is not recognized for header when importing CSV

Anders Bodilsen 26 Reputation points
2023-05-14T08:19:38.8566667+00:00

Hi,

Trying to my luck here as well.

I have asked the following question on stackoverflow.

https://stackoverflow.com/questions/76245122/line-break-is-not-recognized-for-header-when-importing-csv

All suggestions is happily received.

Thanks

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
    2023-06-12T13:22:28.3166667+00:00

    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
    2023-05-15T03:02:52.5633333+00:00

    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.

    Regards´╝î

    Zoe Hui


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

    0 comments No comments