Post reply

Run SSIS under scheduled task

  • July 10, 2015 at 11:04 pm

    #398729

    Hi Team,

    We have few SSIS which run via dot net code. This code is invoked via Windows scheduled task.

    SSIS makes a connection to the DB , I have set it as Integrated security to SSPI.

    My Question: If I set to run the scheduled task under a service account , will this account be used to connect to the database within SSIS?. This service account has all the access to the DB's

  • July 11, 2015 at 10:16 am

    #1811814

    Yes the service account is used by default

    If you don't want to use the service account then you have to create a proxy connection

    :w00t: !!!GOOGLE IS YOUR BEST FRIEND!!! :w00t:

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

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