Home Forums SQL Server 2005 T-SQL (SS2K5) Need some eyes on a SP I'm working on RE: Need some eyes on a SP I'm working on

  • June 25, 2013 at 12:40 pm

    #1627260

    I'm using a Schema.ini file because when I load these files without one, the data becomes garbled.

    "Load these files" how and where? I'm asking because one of the biggest problems you're having seems to be with the creation of the Schema.Ini file for each file. If you're using something like BULK INSERT, the Schema.Ini file isn't necessary. You can just change to a "raw" type file setting.

    Also, you didn't answer my question. Why can't we move "all" the files at once and send a single email with the list of files moved?

    --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)