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 ...

Get SQL Server 2017 Integration Services Cookbook 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