How to we use execute query activity with parameter for ODBC as a provider?
Issue Description
How to use execute query activity with a parameter for ODBC as a provider?
Resolution
- For ODBC as a provider, use "?" instead of "@" for the parameters.
Example:- SELECT * FROM Employees WHERE EmployeeID = ? AND Department = ?
Read more on Binding Parameters ODBC .