Home Forums SQL Server 2005 SQL Server 2005 Integration Services Flat files without delimiters RE: Flat files without delimiters

  • February 25, 2008 at 10:19 am

    #781656

    karthi (2/25/2008)

    Hi,

    I have a flat file without delimiters. The format is like

    L10123444 221

    but Col1 = L;col2=1;col3=0123444 etc...

    how to import this kind of flat file

    Thanks in advance

    All of the methods suggested, so far, are good and will do.

    If you want absolute blinding speed, though, using Bulk Insert with a BCP format file will out perform just about anything else you can do. The information for a BCP format file is in Books Online.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)