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. In SSDT, open the SSISCookbook.sln solution, located in the C:\SSIS2016Cookbook\Chapter06\Starter\SSISCookbook\ folder.
  2. Open the StgAddress.dtsx package, locate the dft_Staging_StgAddress data flow task in the control flow, and open it in the data flow designer.
  3. Click on the empty canvas of the data flow designer to make sure that the data flow as a whole is selected.

 

 

  1. In the Properties pane, you should now have access to the data flow properties.
  2. Locate the EngineThreads property, and set its value to the minimum number of 2, as shown in the following screenshot:
  1. Save the package.

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