Error Description in Error Output Re-Direct Row

Introduction

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

https://msdn.microsoft.com/en-us/library/ms345164(v=sql.100).aspx

Hope you like it.

Posted by: MR. JOYDEEP DAS