Post reply

Executing an SSIS package "through" a firewall

  • July 9, 2008 at 10:03 pm

    #184490

    Setting: Public Web Server ("ServerA"), DMZ\Firewall, and internal SQL 2005 server ("ServerB").

    The Web server does NOT have SQL 2005 installed.

    A developer needs to run a webservice on ServerA that executes an SSIS package on ServerB. Can this be done given the Servers are seperated by a firewall?

    TIA,

    barkingdog

  • July 10, 2008 at 6:14 am

    #840746

    To execute an SSIS package, you MUST be executing it on an SSIS Server of the appropriate edition of SQL Server to run the components included in the package.

    So, your plan will not work. You will need to create a web service on the SQL Server, use some kind of RCMD, use a stored procedure, or use the Job agent to start the SSIS package.

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

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