SSIS Data Profiling Task - support non-SQL ADO connections

SSIS Data Profiling Task - support non-SQL ADO connections by Mike Honey - Manga Solutions

Closed

as Won't Fix Help for as Won't Fix

Type:	Suggestion
ID:	766666
Opened:	10/8/2012 8:42:52 PM
Access Restriction:	Public

Workaround(s)

view

The SSIS Data Profiling Task and Data Profile Viewer are very valuable tools. Unfortunately they are currently limited to source data that exists in Microsoft SQL Server. In a common integration scenario, the source data is being pulled from another source (e.g. Oracle) into a target of SQL Server, so the Data Profiling activity should be carried out against the source data. By the time you have already extracted the data into SQL Server, the Data Profiling activity is either redundant, much less useful, or implies rework.

Details (expand)

English

Integration Services (DTS)

Allow the SSIS Data Profiling task to connect to non-Microsoft SQL Server data sources. I understand their is a technical dependancy on creating objects in a Microsoft SQL Server tempdb - this could perhaps be accomodated by a separate Connection Manager and a generated Data Flow Task to copy the source data into a tempdb table.

Faster Development

Data Profiling against non-Microsoft SQL Server data sources would be a hook to introduce Microsoft-resistant sites to the benefits of the Microsoft BI stack.

0 attachments

Posted by Microsoft on 1/18/2013 at 1:05 AM

Hi, thank you for your feedback. We have investigated the need to support non-SQL ADO connections. The scope and impact of supporting this does not meet our criteria at this point.

Posted by Microsoft on 1/18/2013 at 1:05 AM

Hi, thank you for your feedback. We have investigated the need to support non-SQL ADO connections. The scope and impact of supporting this does not meet our criteria at this point.

Posted by Mike Honey - Manga Solutions on 10/10/2012 at 7:53 PM

It would also be very helpful to be able to send a SELECT statement to the Connection. This would allow filtering of the rows and/or columns to streamline or be more specific. It would also consolidation of Data Profiling Tasks when Profiling a normalized database - multiple tables could be joined together.