In this article we are trying to provide simple error code description by script task. I try to make the script task as simple as possible that every developer can use it. The code of the Script task is just a single line code written in C# language. Hope it will be useful.
The Data Flow Task of the Package
Configuring the Script Task
Step – 1 [ Input Columns Tab ]
Step – 2 [ Inputs and Outputs Column Tab ]
Select the Output columns and click the Add column Button to add output columns. We must change the property of Newly Output columns data type and size.
Step – 3 [ Edit Script Button ]
Need a single line code here.
public override void Input0_ProcessInputRow(Input0Buffer Row)
Row.ErrorDescription = this.ComponentMetaData.GetErrorDescription(Row.ErrorCode);
Step – 4 [ Text File Destination ]
Step – 5 [ The Error Output Flat file ]
Error Description Details from Microsoft
Hope you like it.
Posted by: MR. JOYDEEP DAS