Scheduling a SQL job to run a package

  • Hi everyone. I’ve created a package and it runs fine,,when launced within integrated services. When I attempt to run a scheduled sql job to launch the package it fails, regardless of what account I use. It keeps attempting to run under the SQL instance service account, regardless of what account I tell it to run under. Anyone have success in creating a SQL job to run a SSIS package? Thanks to everyone for being there to help.

    SQL 2005

  • Hi,

    Can you check whether the account is having required permission to execute the job?

    The user (running sql agent service) should have the proper permission.

    DTEXEC /FILE "C:\PackageName.dtsx" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING EW /SET "\Package.Variables[User::SQLInstance].Properties[Value]";"ServerName"

    Regards,

    Vara.

  • You can set the package owner in the Visual studio and if the owner of the package and the account to run the package are same. It will be easy for you to get it work.

  • You can also try creating a SQl server agent proxy with the same user name as the one that created the package and have the job run under this.

    Jayanth Kurup[/url]

  • When you schedule a SSIS package and when it runs as scheduled job , if windows authentication is used inside the package then it will sure take sql server agent service account. If you have called any folder make sure you have right privilege for the sql server agent account.

    Pls refer the below link for scheduling package

    Scheduling SSIS package

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply