Home Forums SQL Server 2012 SQL 2012 - General Skip rows when import a Flat File RE: Skip rows when import a Flat File

  • January 3, 2018 at 8:25 am

    #1974241

    Luis Cazares - Wednesday, January 3, 2018 7:02 AM

    Vitor da Fonseca - Wednesday, January 3, 2018 5:58 AM

    Hi,
    I need to import two Flat Files, but I need to skip the 2nd and 3rd row from one of them (Headers in 1st row) and the other I need to skip the last two rows.

    - sample of Flat File 2nd and 3rd row:
    Row 1 - Header 
    Row 2 -12/01/2017 00:00    12/31/2017 0:00                                                                            
    Row 3 - No of Complete Downloads    No of Partial Downloads    Asset Name    Series Info    Genre Desc    Sub Genre Desc    Provider Brand    Provider Id
    - sample of Flat File last two rows:
    Row *** - Period From    Period To
    Row *** - 01/10/2017 00:00    31/10/2017 00:00

    Any help is very much appreciated
    Thanks in advance,

    Before answering, we need a special piece of information. How are you importing the files?

    Hi,

    I intend to import the data with an SSIS package, which would load the source file from a defined location.
    Please bear with me as I am quite new to SQL, still loads to learn.
    Thanks in advance,

    All help and Any help is appreciated