Good morning,

When I try to use a Global Variable created in an ActiveX script within a SQL or data driven task as a date parameter, I get an error message "wrong number of arguments."

I can execute the exact same SQL against the database substituting the date parameter holders with the exact values in the variables, but when I parameterize them, it fails with the above error.

I've tried using strings as the date parameter in the format of '2004-04-01' which is generally what I use when querying DB2 - including and discluding the apostrophes. I've used the SQLServer date datatype which is properly populated.

Has anyone else had trouble with this? Any solutions?

Thank you very much for your help.

-Brad