Task Factory SalesForce.com Source: Allow use of variable that holds entire query
It would help to be able to set up the entire query within a variable with the WHERE Id IN clause listed
The SalesForce Source supports the use of an IN clause using a variable. This seems to address this request.
Delora Bradish commented
Our client is needing this feature as our Salesforce DEV environment is of a different version than their Salesforce PROD environment. Without a Salesforce source variable option, we are having to create multiple DTSX packages for each Salesforce version. It would be nice to pass a variable value from a metadata table.