error in Execute SQL Task with parameter
Have you actually tried executing the package or are you just trying to parse the query?

Attempting to parse OLE DB queries with params will fail with the error you've described. Don't parse the query if using OLE DB. 

I've created your task and tested. It executes fine, but if you click "Parse query" it returns the same error that you are getting.