• If you can create SQL Agent Jobs on the DB server, there is no logical reason why they should not let you load your SSIS package onto the DB server as it is after all just a big set of scripts at it's heart.

    The DB server has to run the package, wherever it is stored and if you are forced to store it on the App server, then they will need to provide you with an account on the DB server that can access the app server over the network to read the package file.

    If however, you explain to them that uploading the package into SSIS on the DB server is the alternative that means they do not need to provide and support the network account, they should say yes.

    Either way, the job runs on the DB server, but the second way doesn't require network access privileges (unless the SSIS package requires them of course).

    From the App Server, how can I execute SQL Server Agent jobs that reside on a remote DB Server

    connect to SQL and EXEC sp_start_job passing it the job name.

    which execute Packages that reside on the App Server?

    Don't. Load them into SSIS on the DB server - they are just scripts, not applications...

    But the larger question is how you totally separate SQL Database and SSIS on different servers when you have SQL 2012 on one server and only Visual Studio 2008 R2 on the other?

    You don't. SSIS needs to be installed - you can't install it on your App server by your own comments....

    MM



    select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

  • Forum Etiquette: How to post Reporting Services problems
  • [/url]
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
  • [/url]
  • How to Post Performance Problems - by Gail Shaw
  • [/url]