Post reply

SQL server 2014 and VS 2013 - can we run the same package for mutiple SQL jobs at the same time after deployment?

  • May 15, 2015 at 12:18 am

    #308132

    Hello Everyone,

    I would like to deploy one SSIS package at SSISDB database at SQL server 2014. This package is common for multiple clients and a separate SQL job needs to be configured per client. Meaning, for 3 clients, I will be having 3 different SQL jobs which would be configured using the same package.

    My question is, if I would like to execute couple of SQL jobs at the same time for two of my clients then will the package, configured inside these two SQL jobs would run at the same time?

    Any help would be much appreciated.

    Thanks,

    Ankit

  • May 16, 2015 at 4:38 pm

    #1798468

    ankithimmatlalshah (5/15/2015)

    Hello Everyone,

    I would like to deploy one SSIS package at SSISDB database at SQL server 2014. This package is common for multiple clients and a separate SQL job needs to be configured per client. Meaning, for 3 clients, I will be having 3 different SQL jobs which would be configured using the same package.

    My question is, if I would like to execute couple of SQL jobs at the same time for two of my clients then will the package, configured inside these two SQL jobs would run at the same time?

    Any help would be much appreciated.

    Thanks,

    Ankit

    If the packages are run with different configurations for every instance, the answer is yes.

    😎

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

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