Parsing Error

Question

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.

Please advise, Thanks a lot in advance...

Answer 1

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.