No data rows in profiler output file

Ask a question. Quick access. Search related threads. Remove From My Forums. Answered by:. Archived Forums.

Sign in to vote. I need the output of data profiler in a excel sheet. I see that the data profiler only saves the result in a xml file and you need to use data profile viewer to see the results Is there a way to see the results in a excel report? Thursday, May 15, AM. This simplifies the configuration and makes it easier to discover the characteristics of unfamiliar data. When the task runs, the task profiles every column that has an appropriate data type. Quick Profile You can select Quick Profile to configure the task quickly.

A Quick Profile profiles a table or view by using all the default profiles and default settings. The following table lists the custom log entries for the Data Profiling task. You can specify whether this XML output is saved in a file or in a package variable. From the webpage, you can save a local copy of the schema.

You can then view the local copy of the schema in Microsoft Visual Studio or another schema editor, in an XML editor, or in a text editor such as Notepad. The data profiling components do not include built-in functionality to implement conditional logic in the workflow of the Integration Services package based on the output of the Data Profiling task.

However, you can easily add this logic, with a minimal amount of programming, in a Script task. This code would perform an XPath query against the XML output, and then save the result in a package variable.

Precedence constraints that connect the Script task to subsequent tasks can use an expression to determine the workflow. For example, the Script task detects that the percentage of null values in a column exceeds a certain threshold. When this condition is true, you might want to interrupt the package and resolve the problem before continuing.

The editor has two pages:. General Page On the General page, you specify the output file or variable. You can also select Quick Profile to configure the task quickly to compute profiles by using the default settings. Profile Requests Page On the Profile Requests page, you specify the data source, and select and configure the data profiles that you want to compute.

For more information about the various profiles that you can configure, see the following topics:. Skip to main content. This browser is no longer supported. Download Microsoft Edge More info. Contents Exit focus mode. Is this page helpful? Please rate your experience Yes No. Any additional feedback? Note This topic only describes the features and requirements of the Data Profiling task. Was this information helpful?

Yes No. Thank you! Any more feedback? The more you tell us the more we can help. Can you help us improve? Resolved my issue. Clear instructions. Easy to follow. No jargon. Pictures helped. Didn't match my screen. Incorrect instructions.