We are pleased to announce that we are working on a SQL Server Integration Services Data Flow component that will let you integrate your SharePoint data into your SSIS process.
We will provide all the features available in our current Reporting Services Data Extension into a SSIS source component:
- Support for recurring events
- Support for multiple values
- Ability to roll up items in an entire site collection
- SQL Select syntax to refine your query without relying on complex data flow transformation.
- Graphical Query Builder
A SSIS component is the perfect complement to our live reporting solution when, for some scenario, very large datasets are involved or when you would like to consolidate data from multiple sources into SQL data bases for analytic purposes.
If you would like to get an idea, a short video preview is available: