Exploring data using the SSIS Data Profiling Task

In this section, we'll define a very simple SSIS package with two Data Profiling Tasks: one for the SourceData.Contracts table, and a one for the SourceData.Actions table. The results of both Data Profiling Tasks will show a distribution of data, missing values in data, and so on. For this part of data exploration, we need to create a new SSIS project in Visual Studio. We are going to create a new project with the following steps:

  1. Open Visual Studio.
  2. Go to the File - New... menu and select the Project option.
  3. The New Project dialog appears. Select the project template named Integration Services Project.
  4. Give the name Phones to the project, select a location for the project, and then click ...

Get Hands-On Data Science with SQL Server 2017 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial