July 25, 2013 at 7:29 am
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.
July 25, 2013 at 8:30 am
Sounds like a permissions issue to me. Does the credential the proxy account uses have access to the path where the checkpoint file is?
Thanks,
Simon
July 25, 2013 at 8:40 am
it does. It has read/write/modify permissions
July 25, 2013 at 8:41 am
Have you checked Run in 64 bit Mode?
Worth a check.
July 25, 2013 at 8:43 am
If you've got an environment variable package configuration, I think you need to restart SQL Server after you add or change it.
John
July 25, 2013 at 8:44 am
Ok so at what point does it fail, trying to create the checkpoint file, or trying to read it?
July 26, 2013 at 6:44 am
the issue ended up being that I was using a copy of the ssis package when i was trying to troubleshoot. Any changes I made was not saving to the package where the job was calling it
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply