I have two servers, one that has my datawarehouses broken into three SQL instances. The other has SSRS, names the same as the three instances. The SSRS report databases are also on the first server.
My second server only has SSRS. I need to enable SSIS to do ETL for all three instances.
Question: Should I put SSIS on the SSRS server or my database server.
Question: Can each instance (three) have its own SSIS so I can to ETL for each one.