Home Forums SQL Server 2012 SQL 2012 - General SSMS connection to SSIS with packages on remote MSDB server - is that even remotely possible? RE: SSMS connection to SSIS with packages on remote MSDB server - is that even remotely possible?

  • In my experience scaling out SSIS in that manner isn't possible.

    In fact I have a Connect ticket suggesting this as a feature, and extending this concept further by connecting multiple SSIS servers to the same centralized SSISDB (SQL instance), achieving some form of centrally-controlled distributed data processing cluster.

    If your end goal is to simply kick-off an SSIS package (on Server 2) from a SQL Server Job Agent Job (on Server 1), you could potentially achieve this by having the SSIS package in the file system (along with any configuration files) on Server 2, and then executing the SSIS package through command-line using PSExec, which will be triggered from a Job on Server 1... You could probably achieve a remote command call using PowerShell too.

    -----------------
    ... Then again, I could be totally wrong! Check the answer.
    Check out posting guidelines here for faster more precise answers[/url].

    I believe in Codd
    ... and Thinknook is my Chamber of Understanding