Wrappers for SQL queries to the SSIS database.
This is a simple WCF service wrapper for a few of the operations that the SSIS database exposes. To avoid linking SSIS dll's the service connects to the database and calls stored procedures.
It accesses views in the SSISDB.catalog schema, but does not write anything except through stored procedures.
It is under development and currently exposes basic functionality for listing, running and checking packages.
The service exposes the following methods.
Execute a package on the SSIS server.
Get package information for a single package.
Lists packages in a project.
Lists operations that are running / have run for a package.
Fetches operation details for a single operation.
Lists operation messages generated by an operation.
Lists all folders.
Gets folder details for a single folder.
Lists projects in a folder.
Gets project details.
You are free to use this change/update this application for whatever purpose you need. The application is provided as is with all source code. The developer of this project is not resposible for the stability of the code. Feel free to contact the author if you make any extensions / additions you feel should be in the solution.
This application uses the following libraries, besides standard microsoft libraries.