How To Use Execute Query With Parameter For ODBC Provider?

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 .