SSIS - ERROR OUTPUT In OLE DB DESTINATION

Am new to SSIS and developing a component which pulls data from a staging table and drops them into another table in the same database.

Am using a
1) OLE DB Source to get the data from the staging table.
2) OLE DB Destination to insert or push the data into another table of the same database.
3) Script component to get the error rows and to update the staging table column with a flg value.

The rows that throw an error like primary key violation, or any other error should be redirected to the script component and the process should get completed.

The Error Output of the OLE DB Destination doesnt show any columns to be selected for Redirect Row option

The script executes without any error and the records are shown in error path but the records are not updated in the DB.




This is what i have in the script


Public Class ScriptMain

Inherits UserComponent

Dim sqlConn As SqlConnection

Dim sqlCmd As SqlCommand

Dim connMgr As IDTSConnectionManager90
Dim txnIdParam As SqlParameter

Dim errorDescParam As SqlParameter



Public Overrides Sub AcquireConnections(ByVal Transaction As Object)

connMgr = Me.Connections.ErrorConnection

sqlConn = CType(connMgr.AcquireConnection(Nothing), SqlConnection)

End Sub

Public Overrides Sub PreExecute()

sqlCmd = New SqlCommand("UPDATE STG_TRANSACTION SET ERROR_FLG='Y' AND ERROR_DESC=@errorDescParam WHERE TXN_ID=@txnIdParam ")

fueltxnIdParam = New SqlParameter("@txnIdParam", SqlDbType.BigInt)

errorDescParam = New SqlParameter("@errorDescParam", SqlDbType.VarChar)

sqlCmd.Parameters.Add(errorDescParam)

sqlCmd.Parameters.Add(txnIdParam)

End Sub

Public Overrides Sub Input0_ProcessInputRow(ByVal Row As Input0Buffer)

sqlCmd.Parameters("@txnIdParam").Value = Row.TXNID

sqlCmd.Parameters("@errorDescParam").Value = Row.ErrorCode

End Sub

End Class


Pleas let me know the solution and any help will be appreciated.