While working on the new SSIS server to find the better place where we can centrilize all of our SSIS packages
i have a couple of questions.
Unfortunatelly we can not have dedicated SSIS server because of the budget but i was offered to store SSIS packages eather on the active/passive clustered server where our distirbutor database located(only Distributor located on this server) or to have separate Virtual server.
The problem is that i don't know how effecient is to have Virtual server in production environment
and i would like to get your opinion on this.
I know that is hard to tell without knowing the actual configuration but still.
Also, High Availability is very important for SSIS.
All our servers will be in active/passive configuration
How do you implement High Availability for SSIS?
So far i found this article which giveme some ideas.