Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Andy Jones Loading a Series of Flat Files RE: Loading a Series of Flat Files

  • May 9, 2006 at 1:18 pm

    #636864

    Andy,

    THANK YOU, THANK YOU, THANK YOU!!!!!

    In the bowels of your code, I finally found what I've not been able to find anywhere else... a replacement for using xp_CmdShell (security risk) to run a DIR command. 

    I knew that xp_DirTree would create a list of sub-directories off a given path but I didn't know it would produce a level controled list of files, as well (although I thought it should because it also uses XPStar.dll) which is why I kept looking).  Even the SQL "Black Book" didn't have the 'level' and 'filesflag' switches that you incorporated into your code.

    So even though your article is over 4 years old, I just wanted to say "Thanks"... you've made my job a heck of a lot easier ("Look Ma!  No DTS!!!  YIPPEEE!!!")

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