Hello,

I am using 'Microsoft OLE DB Provider for SQL Server' as the data source for
my connection.

But everytime after adding a '?' in my Execute SQL task when I try clicking
on the parameter button to use a global variable, that I have defined in the
package properties, I get an error saying:

"An Error occured while parsing the SQL statement for parameters. Please
check the syntax of the SQL statement and verify that it is valid for the
connection selected"

I need to use global variables in my package. My question is how do I make
changes to my connection to use the global variables?

Thanks.
JK.