Thanks. I went ahead and in the Parameter mapping section of the interior SQL Task and set this...
Variable Name: User::WEBfeWBPhaseID
Direction: Input
Data Type: LARGE_INTEGER
Parameter Name: 0
Then in the task, I use ? where I need the variable. Here's my question. Can I use it more than once?
When I run the SSIS, I get this error...
failed with the following error: "Syntax error, permission violation, or other nonspecific error". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.