Monday, 23 January 2017

Error Description in Error Output Re-Direct Row

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

No comments:

Post a Comment