Data Profiling Task givin NullRatioReq is invalid

• polkadot

  SSChampion

  Points: 13664

  More actions

  January 31, 2016 at 12:37 pm

  #315459

  Working on local machine, SQL Server 2012.

  For practice, before I attempt to use DataProfiler on work servers, I want to do a full profile of every Adventureworks2012 table on my local machine where I have admin permissions.

  steps:

  1. add Data Profiling Task to control flow

  2. configure settings in Task Editor as follows:

  destination type: fileconnection

  destination: file.xml

  overwritedestination: true

  quick profile: adventureworksdatabase

  table: ALL

  3. I run this and get error:

  [Data Profiling Task] Error: Error occurred when profiling the data. The error message is: System.NullReferenceException: Object reference not set to an instance of an object.

  at Microsoft.DataDebugger.DataProfiling.ColumnParameterCollectionUtil.Contains(ColumnParameterCollection noWildCardColumnsX, ColumnParameterCollection noWildCardColumnsY)

  at Microsoft.DataDebugger.DataProfiling.TableInfoInternal.IsDeclaredKey(ColumnParameterCollection cols)

  at Microsoft.DataDebugger.DataProfiling.CandidateKeyProfileCallBack.ComputeProfileFromSchema(ProfileRequest request, TablePartitionedBatch batch)

  at Microsoft.DataDebugger.DataProfiling.TablePartitionedBatch.ComputeProfiles()

  at Microsoft.DataDebugger.DataProfiling.BuiltInProfiler.Profile().

  Selected a single table instead of ALL and works fine. I can view results. Only when I choose ALL do I get error.

  Anyone have experience with Data Profiler and can provide suggestions for how to get all tables profiled and results sent to xml file???

  --Quote me