Home Forums Data Warehousing Integration Services How to import top row only and ignore other rows using SSIS RE: How to import top row only and ignore other rows using SSIS

  • September 23, 2013 at 7:11 am

    #1652325

    Thanks for your reply. I am trying to import a flat file into an SQL Server table.

    The file structure is as follows:

    3178593|M120|010|3206304|AF-01566|20130917|1123|3

    0007|900548|00002|||00000.000|TOS

    0013|3043213|00001|||00000.000|EOE

    0014|270652|00001|75-104||00000.000|TOS

    I am only interested in importing the first row. On a daily basis i may have multiple files, but the only row I am interested in importing is the top row.