Post reply

Scheduling a SQL job to run a package

  • October 14, 2007 at 6:54 pm

    #180448

    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

  • October 14, 2007 at 10:27 pm

    #741876

    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.

  • October 15, 2007 at 12:44 am

    #741884

    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.

  • October 18, 2007 at 5:07 am

    #743067

    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]

  • October 27, 2007 at 10:10 am

    #746006

    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

    Regards..Vidhya Sagar
    SQL-Articles

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

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