SSIS Data Profiling Task Editor hangs
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
January 8th, 2013 11:51pm
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.
Free Windows Admin Tool Kit Click here and download it now
February 1st, 2013 3:53pm