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

  • January 10, 2018 at 7:05 am

    #1975267

    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,

    Please do a dump import to a staging table in your PreProd  table and Use ROW Number() to ignore the rows as you want.
    Please note this approach will not help very well with large dump.