SSIS package fails when scheduled

  • 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?

  • 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.

  • 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