June 21, 2010 at 8:48 am
I have a job/SSIS package that imoports data from an MS Access database that resides on a Citrix server and then dumps it into a normalized version of the db in SQL. The first step in the job imports a table from the MS Access db, and this is the one that fails. When you run the job manually it runs fine. When you schedule it it fails and says that the SQLSERVICES profile doesn't have access to the Access db that the source data resides in. Does anyone know why this is happening and what can be done to resolve the issue?
June 21, 2010 at 9:05 am
Hi,
As far as I am aware, Jobs scheduled under SQL Agent will run with the permissions of the account that runs the SQL Agent Service - so check whether that account has the required permissions.
Hope this helps!
Jinx.
June 22, 2010 at 4:14 pm
Hi there
Not sure if you have already checked this, but pleased double check all your permissions...
Also find attached is a document that might help you out a bit
Cheers & gud luk
Vani
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply