EndOfRowset doesn't work - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SSIS and Import/Export (2005)

EndOfRowset doesn't work

Author

Topic

MJalbert
Starting Member

1 Post

Posted - 2010-02-25 : 10:52:54

Hi all,

I've got a pretty weird error. I've developed an SSIS Custom Task in VB.NET on SSIS 2005. To read the inputbuffer, I've created a class that creates a layer to read the buffer easily.

The problem comes from the EndOfRowset property, it always returns me "False" here is code:


    Public Sub ValiderListe(ByRef source As Commun.PipelineBufferEtendu, ByRef cible As Commun.PipelineBufferEtendu)
        Me.source = source
        Me.cible = cible 

        While source.nextRow

            ValiderLigne(source)

        End While

        logOut("EndOfRowset = " & source.EndOfRowset)
    End Sub

In my logs, EndOfRowset is always false.

Here is how, in my custom task, I initialize my source (custom buffer):


    Public Overloads Overrides Sub ProcessInput(ByVal inputID As Integer, ByVal buffer As PipelineBuffer)
        If buffer Is Nothing Then
            Throw New ArgumentNullException("buffer")
        End If

        listeSource = buffer

        If (listeSource.RowCount > 0) Then
            Me.classValidation.ValiderListe( _
            New Commun.PipelineBufferEtendu( _
                listeSource, ComponentMetaData.InputCollection(0), _
                BufferManager), _
            New Commun.PipelineBufferEtendu( _
                listeCible, ComponentMetaData.OutputCollection(0), _
                BufferManager))
        End If

        If listeSource.EndOfRowset Then
            listeCible.SetEndOfRowset()
        End If
    End Sub

I've tried with an OLE source and a Flat File source, both doesn't work.

Anyone has an idea?

Thanks a lot,

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources