Post reply

Has anyone ever pbuilt a separate server just for SSIS and how did you do it?

  • March 18, 2015 at 11:35 am

    #296164

    Has anyone ever built a separate server just for SSIS and how did you do it?

    Jared
    CE - Microsoft

  • March 18, 2015 at 2:09 pm

    #1784901

    I've done this a couple times. Once for a centralized SSIS server for all packages enterprise wide and once to offload SSIS processing for a Data Warehouse. In both instances, I installed SSIS and the Data Engine so we could use SQL Agent to schedule the packages. Only the system databases were allowed on these SSIS servers.

  • March 18, 2015 at 2:30 pm

    #1784909

    We do the same thing as JeremyE. With SQL 2012 you need the engine if you plan on using the SSIS Catalog as you now do all your managing of packages by connecting to the engine rather than the ssis service.

    I like having all packages and related jobs on a dedicated server, that way it keeps the agents clean on my oltp and olap servers and I don't have to worry as much about a developer making a package that spikes cpu and slows down a production application.

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

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