Post reply

Run SSIS package in JOB

  • June 27, 2012 at 11:20 am

    #392616

    Hello all

    Please suggest me what are the configurations and pre requisites required to set up a job that runs SSIS package.

    Issue: Pulling data from prod box to dev box. Job should be running on dev box.

    Let me know some points:

    1.wht service accounts that dev box sql server and sql server agent should run

    2.who should be owner of the job

    3.what account should be in "Run as" in setting up job

    Struggling on this from 10 days please help

  • June 27, 2012 at 11:24 am

    #1506298

    Sqlism (6/27/2012)

    Hello all

    Please suggest me what are the configurations and pre requisites required to set up a job that runs SSIS package.

    Issue: Pulling data from prod box to dev box. Job should be running on dev box.

    Let me know some points:

    1.wht service accounts that dev box sql server and sql server agent should run

    2.who should be owner of the job

    3.what account should be in "Run as" in setting up job

    Struggling on this from 10 days please help

    1. Depends on your corporate policy. many places do not allow the same service account to run a dev instance as well as a prod instance.

    2. My preference for owner of the job is sa. Others will have other preferences

    3. If you want to use a proxy account to run this job, then the account that should be in that setting is one that you have created as a proxy and that has access to both environments and any fileshares that the job may access.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 2 posts - 1 through 1 (of 1 total)

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