I'm seeking help from a real SSIS expert, which I'm not to any extent.
I recently developed an open source project called "Extended TSQL Collector" and can be found here https://extendedtsqlcollector.codeplex.com
The purpose of the project is to provide a new collector type to the built-in Data Collector collectors to work around some limitations.
Basically, a collector type is made of two SSIS packages: one to collect the data and one to upload it to the MDW database.
In my case, both packages are invoking an external application which takes care of everything. To invoke the application, I use an execute process task.
Everything works fine when the SSIS components are installed, but fails when SSIS is missing, which is understandable to some extent.
What puzzles me is that the other built-in collector types work flawlessly even if SSIS is not installed.
- Which tasks are installed with the database engine services and don't need to be installed with SSIS?
- Is there a way to install the Execute Process Task other than installing SSIS?
- Can I programatically check if a SSIS task is installed?
How to post T-SQL questionsspaghettidba.com@spaghettidba