Please try to do the following - in parameter mapping replace "?" with "0". I did it like that with OLE DB data source and worked.  

Select ProductID, ProductName

from Production.Product

Where ProductID = ?

The Parameter mapping page looks like this:

User:roductID, Input, Long, 0