Parsing Error

Puneet Kumar 1 Reputation point
2021-02-02T22:04:19.503+00:00

Hello experts,

  1. I am reading txt files (which has sql queries) and concatenating it to a array variable.
  2. Then I convert it back to a string variable using the following expression
    @replace(replace(join(variables('sql_query'),' '), '\n', ' '), '\r', ' ')
  3. Then I pass this variable to a Mapping Data Flow
  4. But it fails there telling me that there's Parsing error.

I have tried all the expressions from different links but nothing seems to work out.

63231-image.png

Please advise, Thanks a lot in advance...

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,753 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Kiran-MSFT 691 Reputation points Microsoft Employee
    2021-02-04T05:52:12.56+00:00

    Make sure you escape line feeds with \n. The actual string parameter you pass should have a literal \n (2 characters in it).
    The dataflow DSL script does not accept strings with line feeds unless escaped.

    0 comments No comments