Project Deployment Model and Distributed Architecture


  • I converted some SSIS 2008 packages to use the the new Project Deployment Model. This works as expected. However, I would like to set up the environment so that the database and SSIS sit on separate servers. That way I can have the SQL Server execute a stored procedure which configures and execute a package on the SSIS server. 

    Unfortunately, I have been unable to find any material explaining how to do this. Can any one point me in the direction of any whitepapers etc which explain how to configure a distributed environment.

    Wednesday, August 21, 2013 9:37 AM