O'Reilly logo

SQL Server 2017 Integration Services Cookbook by Dejan Sarka, Matija Lah, Christian Cote

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

How to do it...

  1. Open SQL Server Data Tools (SSDT) and create a new project using the Integration Services Project template. Place the solution in the C:\SSIS2016Cookbook folder and name the project Chapter05.
  2. Rename the default package to DataProfiling.dtsx.
  3. From the SSIS toolbox, drag the data profiling task onto the control flow work area.
  4. Double-click the task to open the Data Profiling Task Editor.
  5. On the General page of the Data Profiling Task Editor, select FileConnection in the drop-down list for the DestinationType property. Select New File Connection from the Destination property drop-down list. In the File Connection Manager Editor that appears, select Create File and enter C:\SSIS2016Cookbook\DataProfiling.xml. Click Open, and ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required