Using SQL Server 2005 Enterprise 64 Bit on SQL Server 2008.

When we create the SQL Agent job on the Server to run the SSIS package we use a :SetVar to update the varables in the SSIS package (database server, and some other vars also). This works fine at first. If one openes the Agent job and presses cancel The Job no longer passes the values into the SSIS package on run.

Anyone seen any issues like this before?


Gary