For SQL Data Collector:
Do you need SSIS (SQL Server Integration Services) installed on the server that you are collecting data from. Or can the packages be run from another server -- like the one that the MDW database is on.
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
Nope, you don't need SSIS on the server you are collecting data from, bits of SSIS are installed anyway when you install SQL server and this is enough for the data collector to work. All the system data collector sets work out of the box once you have set up the management data warehouse and enabled them.
The actual SSIS packages for data collector are stored within MSDB, rather than SSISDB as with a full SSIS server and they are executed by a process called Dcexec.exe.
The full architecture for how data collector works is detailed here: