Hello experts, I am reading txt files (which has sql queries) and concatenating it to a array variable. Then I convert it back to a string variable using the following expression @replace(replace(join(variables('sql_query'),' '), '\n', ' '), '\r', ' ') Then I pass this variable to a Mapping Data Flow 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. Please advise, Thanks a lot in advance...

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.

Parsing Error

Puneet Kumar 1

Hello experts,

I am reading txt files (which has sql queries) and concatenating it to a array variable.
Then I convert it back to a string variable using the following expression
@replace(replace(join(variables('sql_query'),' '), '\n', ' '), '\r', ' ')
Then I pass this variable to a Mapping Data Flow
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.

Please advise, Thanks a lot in advance...

HarithaMaddi-MSFT 10,136 Reputation points

2021-02-03T12:54:03.383+00:00

Hi @Puneet Kumar ,

Welcome to Microsoft Q&A Platform. Thanks for posting the query.

I tried reproducing the issue but I am able to read the variable value accurately in dataflows as below. Can you please try reducing the queries to 2 and check the issue. Also, if possible, please share the sample 2 queries so that we can try reproducing the issue and then can assist you better. Also, please check if "Set variable" output before "Dataflow" activity is as expected.

Looking forward for your response!
Puneet Kumar 1 Reputation point

2021-02-03T18:30:48.263+00:00

Hello Haritha,

Thanks for the response and please find the txt file I am using (There might be multiple files). So I keep it to single line it works but as soon as I try with a file having multiple lines of sql code in it, it starts failing and give me the same error. Please advise Thanks!

63632-queries.txt
Haritha Maddi 26 Reputation points

2021-02-04T12:56:41.547+00:00

Thanks @Puneet Kumar for sharing the queries. I am able to reproduce the issue, I reached out to product team on possible workaround for the same. I will get back to you as soon as I hear from them.

Stay tuned!

1 answer

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.
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Parsing Error

1 answer

Your answer