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, with your project open, right-click on the Control Flow folder in the Package Parts section of the solution explorer. As shown in the following screenshot, select New Control Flow Package Part from the contextual menu. Rename it Chapter2Part.dtsxp.
  1. Drag and drop an Execute SQL task on it:
    1. Rename it sql_Truncate_dbo_CustomLogging.
    2. Click anywhere in the Control Flow. Set its description property to This is a simple template that is meant to truncate the table [dbo].[CustomLogging].
    3. As shown in the following screenshot, right-click in the Connection Managers area and choose New OLE DB Connection... from the menu ...

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