SSIS Parameter cannot be derived from sub-select queries

If you’re trying to use a parameter in a sub query using the SSIS SQL task you may encounter this error :

Edit the SSIS Execute SQL Task and check the ByPassPrepare option
Currently it is set to false, and we generate the error above.


Set the Set the ByPassPrepare option to True:
 
The task will now execute successfully !!