SSIS Data Profiling Task Editor hangs

Question

Windows server 2008 R2, x64, SP 1

SQL Server 2012, x64, SP1

Open SSIS

create new integration Services Project

*.NET Framework 4

Create a new connection Manager (ADO.NET Integrated Security: True

Management Provider: System.Data.SqlClient

drag drop SSIS Data profiler on to control flow

Immediately 2 Error Messages are thrown:

Validation Error. data Profiling Task Data Profiling Task: the "Destination" property is invalid: Missing destination for profile output.

Validation Error. data Profiling Task: There were errors during task validation

Edit Data profiler

DestinationType: FileConnection

Destination: Create File, Browse to current project folder created earlier and enter file name <FileName>.xml

Usage Type: Create File, Select OK

Overwrite Destination: True

Select QuickProfile

ADO.NET COnnection: use conection created earlier

Table or View: Select All tables

Leave all options as defaulted

Select OK

Visual Studio freezes

Windows Applicaiton Event log:

event Id: 1002

Source: Application hang

Description: the program devenv.exe version 10.0.40219.1 stopped interacting with windows and was closed. To see if more information about the problem is availabe, chekc the problem history in the Action Center Control Panel.

Process Id: 1014

Termination Time: 15

Application Path: C:\Program files (x86)\Microsoft Visual Studio 10.0\common7\IDE\devenv.exe

Answer 1

I think you should post this in the SSIS Forums.  DQS has data profiling, but the data profile task in SSIS is not part of the product DQS.