0

I am trying the specify the query on the Datasource in dataflow as show on the below screen capture.

enter image description here

But it is throwing an error, is this the correct way of specifying the columns?

enter image description here

Error:

enter image description here

Improve this question

1 Answer 1

Reset to default
1

at Source '': Incorrect syntax near ''. SQL Server error encountered while reading from the given table or while executing the given query

This error message is because of the syntax error in the SQL query.

  • Do not write the queries within double quotes.
  • In the select query, while giving the column names comma(,) is missing between email and *. This is the reason for your error.
  • Even if you are giving comma in the query, you will get the below error.

at Source 'source1': The column 'name' was specified multiple times for 'T_***'.

  • The reason is, when * is specified, all columns will be displayed. Column name is specified explicitly in the query also. It will result in two columns with the same name, and this is not allowed in dataflow.
  • Thus, it is recommended to give either select * from <table-name> or select<column-name[s]> from <table-name> as a query in Query text box.
Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.