Error column name
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.
Getting ready
This recipe assumes that you have created the CustomLogging
project and package from previous recipe.
How to do it...
- 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...