I have a SQL Server 2008 64-bit SSIS package that runs just fine in BIDS.
However, when i create and run the job, it fails saying it can't find the path for the checkpoint file. I have evaluated the expression that creates the path for the checkpoint file and it evaluates to the correct location.
There are configuration files which go to a SQL server table. There is another configuration file which goes to an environment variable. I have deleted and added back in the configuration file and the environment variable that points to the path for the checkpoint file thinking it was cached somewhere. This didn't do anything.
The SQL server table is SQL Server 2008 R2 SP2.
It seems like the configuration files are not being applied to the job.
The job runs under a proxy account, which has read access to the sql server table.
I have logged into the server the SSIS package runs the job under in order to see if it would run in BIDS, it does. I have also deleted and recreated the job.