You are correct. User::WEBfeWBPhaseID is Int32. I changed the parameter mapping to be LONG but the same error comes up.

The query I've been trying (extremely simple for now)...

Sorry, forgot to add that I tried adding this...

DECLARE @WEBfeWBPhaseID as int

SET @WEBfeWBPhaseID = ?

and then just using @WEBfeWBPhaseID when I need it but I get the same error.

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