1

I've just started using the Data Profiling Task in SSIS to profile some data on our databases. I've found the option for profiling the column null ratios ("Column Null Ratio Profiles") but I'm interested in profiling for the empty string ("") as well as null values.

I've tried googling but not had any luck. Does anyone know if this is possible?

jarlh
  • 42,561
  • 8
  • 45
  • 63
t_warsop
  • 1,170
  • 2
  • 24
  • 38
  • 2
    What you're really asking about is the capability to define custom profiles. The answer to that question is 'No'. However, @Hadi has a great workaround in this related question: https://stackoverflow.com/questions/51665819/data-profiling-task-custom-profile-request – digital.aaron Nov 29 '18 at 16:50

1 Answers1

0

I've looked into this further and there is no built-in profile to achieve what I want.

https://learn.microsoft.com/en-us/sql/integration-services/control-flow/data-profiling-task?view=sql-server-2017 lists the profiles that you can use and there is no "profile the number of blank strings" profile to use.

t_warsop
  • 1,170
  • 2
  • 24
  • 38