SSIS - Error handling

In this article we will learn how to handle the errors in SSIS package. In SSIS when package throws an error then these error details is stored in following variables ErrorCode, ErrorDescription and SourceName.

Below is the code to handle error in SSIS package.
When a SSIS task encounters an error these error details are stored in three system variables.
Dts.VariableDispenser.LockForRead("ErrorCode")
Dts.VariableDispenser.LockForRead("ErrorDescription")
Dts.VariableDispenser.LockForRead("SourceName")
ErrorCode variables returns error code which will be numeric.
ErrorDescription will give us a brief description of an error encountered by the SSIS task.
SourceName give us the task name from which error occured.
Private Sub GetErrorValues(ByRef errNumber As Integer, ByRef errDescription As String, ByRef errSource As String)

            Dts.VariableDispenser.LockForRead("ErrorCode")
            Dts.VariableDispenser.LockForRead("ErrorDescription")
            Dts.VariableDispenser.LockForRead("SourceName")
            Dts.VariableDispenser.GetVariables(vars)
            Try
                errNumber = CType(vars("ErrorCode").Value, Integer)
                errDescription = vars("ErrorDescription").Value.ToString()
                errSource = vars("SourceName").Value.ToString()
            Catch ex As Exception
                Throw ex
            Finally
                vars.Unlock()
            End Try
        Catch ex As SystemException
            Throw ex
        End Try
    End Sub

Comments

C# Generic Factory

Implement Factory pattern using generics public interface IDoWork { string DoWork(); } Declare an Interface first by abstracting the common functionality Here I am taking the example of DoWork public class Manager : IDoWork { public string DoWork() { return "Manager Manages School" ; } } Implement the IDoWork in concrete classes as shown public class Teacher : IDoWork { public string DoWork() { return "Teacher teaches student in school" ; ...

How to enable windows authentication in PostgreSQL

1. Steps to create user or role in PostgreSQL · Open pgAdmin III · Login to PostgreSQL database · Select “Login Roles” and right click on mouse to view the context menu · Select “New Login Role” from context menu · Enter desired user name in “Role name” text box · Select “Definition” tab in “New Login Role” window · Enter desired Password in the given text box · Select “Role privileges” tab in “New Login Role” window · Select the privileges for the entered user or role · Select “SQL”...

UML - Association, Aggregation, Composition, Generalization, Specialization, Realization and Dependency

Association Association is a simple relationship between two classes. For example A relationship between Professor Class and Student class is known as Association. Both Classes can exist without each other, so Professor and Student are two independent classes. In this kind of relationships there will not be any owner class. Both classes have their own life cycle. UML Notation: Aggregation Aggregation is a special type of Association. It is known as “Has-A” relationship. For example A Department class can contain Professor Class. Here Department class is owner class. Here in this relationship even after deleting Department class, Professor Class can exits. UML Notation: Composition Composition is a special type of Aggregation. It is known as “Is-A” relationship. For example A University Class has many Department class. Here University and Department objects are dependent on each other. If we delete Univ...

Prime Instance

Search This Blog