Hi All,

I'm getting a similar error, "[Execute SQL Task] Error: Executing the query "Truncate Table Outcomes.ExtractTrackingTempTrunc..." failed with the following error: "Cannot find the object "ExtractTrackingTemp" because it does not exist or you do not have permissions.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly." when attempting to run an SSIS package that was working fine and deployed to production. I just need to make a change to a parameter, but am running into the above error. Why would it be doing this now, when I know it was fine in production? Any advice would be greatly appreciated!

Thanks.