i'm working on building a generic error handling routine for a
package. I've googled my way to the point where i can iterate thru
the input buffer....but don't know how to get the actual value in the
column buffer so I can copy it into the appropriate output column
buffer. Can anyone offer some advice?....I've included most of the
script -- look for "need syntax here' for specific issue.

Thanks.


Public Class ScriptMain
Inherits UserComponent
Private mErrDesc As String
Private inputBuffer As PipelineBuffer

Public Overrides Sub ProcessInput(ByVal InputID As Integer,
ByVal Buffer As

Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer)
inputBuffer = Buffer
MyBase.ProcessInput(InputID, Buffer)
End Sub

Public Overrides Sub Input0_ProcessInputRow(ByVal Row As
Input0Buffer)
mErrDesc =
Me.ComponentMetaData.GetErrorDescription(Row.Error Code)
Call CreateNewOutputRows()
End Sub

Public Overrides Sub CreateNewOutputRows()
Dim INcolumn As IDTSInputColumn90

errorDescriptionBuffer.AddRow()

For Each INcolumn In
Me.ComponentMetaData.InputCollection(0).InputColum nCollection
'all outputbuffer columns will have same names as
input
' iterate thru input columns and copy values into
output buffer
' >>>>>>>>>>>>>need syntax here >>>>>>>>>>>>>>>>>>
errorDescritpionBuffer.columns(INname).value =
INname.value
' >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Next

errorDescriptionBuffer.errDesciption = mErrDesc

End Sub

Hi Kent,

I think you need to pass the Row from ProcessInput to
CreateNewOutputRows.

If I remember correctly however, if you set the Output's
"SynchronousInputID" property to point to your Input, the output
buffer will automatically contain all of the columns and data from the
input buffer (and any additional columns you create).

Good luck!
J

Hi Kent,

I think you need to pass the Row from ProcessInput to
CreateNewOutputRows.

If I remember correctly however, if you set the Output's
"SynchronousInputID" property to point to your Input, the output
buffer will automatically contain all of the columns and data from the
input buffer (and any additional columns you create).

Good luck!
J

Hi Kent,

I think you need to pass the Row from ProcessInput to
CreateNewOutputRows.

If I remember correctly however, if you set the Output's
"SynchronousInputID" property to point to your Input, the output
buffer will automatically contain all of the columns and data from the
input buffer (and any additional columns you create).

Good luck!
J

Hi Kent,

I think you need to pass the Row from ProcessInput to
CreateNewOutputRows.

If I remember correctly however, if you set the Output's
"SynchronousInputID" property to point to your Input, the output
buffer will automatically contain all of the columns and data from the
input buffer (and any additional columns you create).

Good luck!
J

Hi Kent,

I think you need to pass the Row from ProcessInput to
CreateNewOutputRows.

If I remember correctly however, if you set the Output's
"SynchronousInputID" property to point to your Input, the output
buffer will automatically contain all of the columns and data from the
input buffer (and any additional columns you create).

Good luck!
J

Hi Kent,

I think you need to pass the Row from ProcessInput to
CreateNewOutputRows.

If I remember correctly however, if you set the Output's
"SynchronousInputID" property to point to your Input, the output
buffer will automatically contain all of the columns and data from the
input buffer (and any additional columns you create).

Good luck!
J

Hi Kent,

I think you need to pass the Row from ProcessInput to
CreateNewOutputRows.

If I remember correctly however, if you set the Output's
"SynchronousInputID" property to point to your Input, the output
buffer will automatically contain all of the columns and data from the
input buffer (and any additional columns you create).

Good luck!
J

Hi Kent,

I think you need to pass the Row from ProcessInput to
CreateNewOutputRows.

If I remember correctly however, if you set the Output's
"SynchronousInputID" property to point to your Input, the output
buffer will automatically contain all of the columns and data from the
input buffer (and any additional columns you create).

Good luck!
J

On May 30, 7:47 am, jhofm... (AT) googlemail (DOT) com wrote:
Good news !

I'll give it a try