Share via

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,361 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,525 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  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
  2. ZoeHui-MSFT 35,556 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