Home Forums SQL Server 2005 SQL Server 2005 Integration Services Importing Poorly Formatted Text File RE: Importing Poorly Formatted Text File

  • July 18, 2014 at 7:14 am

    #1730591

    Koen Verbeeck (7/18/2014)

    Ed Wagner (7/18/2014)

    Koen Verbeeck (7/18/2014)

    Jeff Moden (7/18/2014)

    @Koen,

    Now you see why I never get into SSIS. I just don't need it.

    Everyone has his own tool. I can say the same thing about BCP 😀

    You know, Koen, this it the type of thing that almost makes me want to learn SSIS.

    I'd probably start with something simpler, but that's for another day. I haven't found anything that was impossible with SQL yet, but I'm sure that day will come eventually. 😉

    Importing multiple files in parallel 😉

    That's not impossible using T-SQL. Just different. I've built many an ETL that does just exactly that without SSIS. I will, however admit that SSIS allows for more easily (click and drag the right block connector type) "waiting" for a given set of parallel imports to complete before continuing the process but even that's not all that difficult to pull off in T-SQL. It's just different.

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