• 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.