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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics