Hi JIL MODI , Welcome to Microsoft Q&A platform and thanks for posting your question here. Based on the description of your query, it seems you are trying to pass the parameter value into dataflow from lookup output dynamically , however, it's throwing syntax error. Please let me know if that is not the case here.
For such scenario, you need to use escape characters i.e. '' symbol so that it will pass the single quotes in proper format.
Below video has the implementaiton details for the same requirement: Write dynamic expression for SQL with single quotes around parameter value in Mapping data flows Hope it helps. Kindly accept the answer if it helps. Thankyou.