How to skip the last line in an SSIS data stream

Question

I use FlatFile Source Manager→ Script COmponent as Trans→ OLEDB destinationin my data stream.

The source reads all the lines from a flat file, and I want to skip the last line (trailer entry) updating the database.

Since it contains values NULL, the database raises an error.

Help me how to solve this.

Regards, VHK

Answer 1

If you need to avoid lines having null values ​​in a flat file, you can follow below,

• Reading data from a flat file using the source component.
• Conditional Split , case expression !ISNULL(Column1) && !ISNULL(Column2) (Column1 Column2 . , ID , !ISNULL(ID)).
• OLEDB.

, .

Answer 2

, :

• DataFlow Task ( DFT RowCount)
• System.Int32 (: :: RowCount)
• DataFlow Flat File Source (, )
• RowCount Flat File Source
• RowCount User::RowCount

6. DataFlow Task ( DFT Import)

7. DFT Import Flat File Source (, )
8. Script Component Flat File Source
9. User::RowCount Script ReadOnly

10. DT_BOOL (: IsLastRow)

11. Script Script

    Dim intRowCount As Integer = 0
    Dim intCurrentRow As Integer = 0
    Public Overrides Sub PreExecute()
        MyBase.PreExecute()
        intRowCount = Variables.RowCount
    End Sub
    Public Overrides Sub Input0_ProcessInputRow(ByVal Row As Input0Buffer)
        intCurrentRow += 1
    
        If intCurrentRow = intRowCount Then
            Row.IsLastRow = True
        Else
            Row.IsLastRow = False
        End If
    
    End Sub
    

12. Conditional Split Script

13. ,

    [IsLastRow] == False
    

14. OLEDB Destination

: ( ), Script writen Script,