Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL 2008 SSIS package runs in BIDS but not job Expand / Collapse
Author
Message
Posted Thursday, July 25, 2013 7:29 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, July 10, 2014 7:25 AM
Points: 64, Visits: 330
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.
Post #1477480
Posted Thursday, July 25, 2013 8:30 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Tuesday, July 8, 2014 3:18 AM
Points: 702, Visits: 2,169
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




MCSA: SQL Server 2012
Follow me on Twitter: @WazzTheBadger
LinkedIn Profile: Simon Osborne
Post #1477526
Posted Thursday, July 25, 2013 8:40 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, July 10, 2014 7:25 AM
Points: 64, Visits: 330
it does. It has read/write/modify permissions
Post #1477532
Posted Thursday, July 25, 2013 8:41 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, April 25, 2014 7:42 AM
Points: 11, Visits: 116
Have you checked Run in 64 bit Mode?
Worth a check.
Post #1477535
Posted Thursday, July 25, 2013 8:43 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 5:15 AM
Points: 5,208, Visits: 9,369
If you've got an environment variable package configuration, I think you need to restart SQL Server after you add or change it.

John
Post #1477537
Posted Thursday, July 25, 2013 8:44 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Tuesday, July 8, 2014 3:18 AM
Points: 702, Visits: 2,169
Ok so at what point does it fail, trying to create the checkpoint file, or trying to read it?



MCSA: SQL Server 2012
Follow me on Twitter: @WazzTheBadger
LinkedIn Profile: Simon Osborne
Post #1477539
Posted Friday, July 26, 2013 6:44 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, July 10, 2014 7:25 AM
Points: 64, Visits: 330
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
Post #1477973
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse