Advice on importing multiple txt files with different file structures

  • jcrawf02 (9/16/2010)


    Just to make it interesting 😛 my DBAs have deigned not to grant BULK INSERT, so swell though your solution seems to be Wayne, it no workey.

    In light of that roadblock, I'm still working on it in SSIS.

    You can still do it with SSIS although I believe your DBA's have become GUI-centric and a bit fearful ;-). The key is to get the file. It's just not as easy in SSIS as it is in T-SQL.

    As a side bar, I understand some of the FUD about Bulk Insert privs. It seems that too many DBA's have taken the easy way out. My previous System DBA was great. She used to say, "Jeff, you figure out how to make it work well and I'll figure out how to make it work securely." The world needs more DBA's like her. You know... the ones that can actually do their job? 😛

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

Viewing post 16 (of 15 total)

You must be logged in to reply to this topic. Login to reply