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.