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

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