locked
Auto Detect Row delimiter in ADF. RRS feed

  • Question

  • What characters should I give in SQL corresponding to Autodetect delimiter in ADF. I have tried CHAR(10) for '\n' and CHAR(13) for '\r' but it's not working completely. So, my requirement is I need to fetch all the data from SQL to run copy activity pipeline and  I was facing issue with row delimiter.
    Monday, February 3, 2020 6:19 AM

All replies

  • Hi Srikanth,

    If the row delimiter is not specified, the default row delimiter is "\r\n". You can also set a custom row delimiter based on your dataset.

    Hope this helps.

    Monday, February 3, 2020 6:53 AM
  • Hi Mishra,

    I have tried using CHAR(13)+CHAR(10) for '\r\n' in sql but I am getting error 

    Copy activity doesn't support multi-char or none row delimiter.

    Monday, February 3, 2020 6:55 AM
  • Hey Srikanth,

    How about this - you have the delimiter in SQL as you want and then set that in the dataset. The default one corresponds to \r\n, but you can go ahead and set any delimiter that you might already have in your SQL.

    Hope this helps.

    Tuesday, February 4, 2020 9:41 AM
  • Hi Srikanth,

    Just wanted to check - was the above suggestion helpful to you? If yes, please consider upvoting and/or marking it as answer. This would help other community members reading this thread.
    Tuesday, February 18, 2020 7:44 AM