This recipe will show you a new neat feature of SSIS, which is the error column name. We could achieve something similar before SSIS 2016 but it involves using a script component and it is difficult to reuse this kind of transform. Although we can copy and paste a script component from one package to another, every time we do so, we must change the input columns and recompile the script. It's not very difficult but it's a tedious task. The error column name native implementation in SSIS 2016 is very welcome.
This recipe assumes that you have created the CustomLogging
project and package from previous recipe.
- In the
CustomLogging.dstx
package, navigate to thedft_dbo_CustomLogging
by double-clicking on the Data Flow task. Click on the path (blue arrow) between theole_src_SELECT_1
and theole_dst_dbo_CustomLogging
transform to select it. Right-click on it and selectDelete
to delete it.
- Drag and drop a derived column transform from the SSIS Toolbox...