Take the 2-minute tour ×
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's 100% free, no registration required.

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.

share|improve this question

migrated from stackoverflow.com Feb 20 '13 at 19:24

This question came from our site for professional and enthusiast programmers.

1  
This is probably a question for the DBA site (I've voted to move it). I have no personal experience of this feature but the documentation implies that SSIS is only required on the collector, which would fit with the general SSIS model: you only need to install SSIS on the server where you actually execute the package. Have you just tried it? –  Pondlife Feb 20 '13 at 14:38
add comment

1 Answer 1

up vote 2 down vote accepted

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:

Data Collector Architecture

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.