Deployment location for SSIS

Question

I have this scenario which has to be solved by SSIS:

• I have multiple instances of the same DB (they may be on different servers)

• I have one Master DB on a different server

• now I need to transfer data from these different instances to Master DB using SSIS

My question is - where exactly SSIS needs to be installed? On Master DB server? On each of the source DB servers? Both?

Answer 1

It must be installed on the server it will be executed from, it can be a seperate server from master or clients or anyone of them.

Note that if you want to perform Bulk insert operation, then you should install it on master server.

Check the following links to get some insights:

• The Data Loading Performance Guide
• SQL Sever Destination vs OLE DB Destination