How to do it...

  1. In the CustomLogging.dstx package, navigate to the dft_dbo_CustomLogging by double-clicking on the Data Flow task. Click on the path (blue arrow) between the ole_src_SELECT_1and the ole_dst_dbo_CustomLogging transform to select it. Right-click on it and select Delete to delete it.
  1. Drag and drop a derived column transform from the SSIS Toolbox onto the data flow. Link it to the ole_src_SELECT_1 and double-click on it to open the derived column transformation. As shown in the following screenshot, do the following:
    • Derived Column Name: DateToConvert
    • Derived Column: leave it as <Add as new column>
    • Expression: Type 1600-01-00 ...

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