Using Data Profiling Task

Sometimes, you may need to review the data source before initiating processing of the data from that source. You may want to review the source for NULL values in columns, distinct rows etc. This initial analysis of data before processing it may help the developers in building the logic based on that data. To perform such an analysis, Data Profiling Task of SSIS can be used.

To use Data Profiling Task, drag the same from SSIS Tool Box to the Control flow. Double click the task and following window will be displayed:

Untitled

Click the drop down ,create a new File connection as shown below and Click Ok:

Untitled4

Now, since the destination connections are set, we will proceed to set the Requests.

Note: Requests indicate the different ways in which we want to analyze source.

Click the “Quick Profile” button shown in below image:

Untitled1

Configure settings as shown in below figure:

Untitled2

Now click Ok and a dialogue box will open showing the requests selected for analyzing data. Refer figure below:

Untitled3

Now run the Task. Once the execution is completed go to Data Profiler Viewer in Windows or double click the Data Profiling Task and open Data Profiler Viewer as shown:

Untitled5

After clicking the button, following window will open, Click Open as shown in below screenshot:

Untitled7

Browse to the location of XML file as specified in Destination of Data Profile Task. Click OK and following window will open:

Untitled6

Now select any of the options pointed in above figure and fetch the source information.

Like the page http://www.facebook.com/pages/SSISBlog/200678990060457  if the blog helps you in any aspect

Happy Coding!! Cheers!

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s