Home Forums Data Warehousing Integration Services For Each Loop Uploads the Same File Infinitely RE: For Each Loop Uploads the Same File Infinitely

  • September 22, 2013 at 11:50 am

    #1652199

    Vikash Kumar Singh (9/21/2013)

    If you could share your design of SSIS that might be helpful to resolve this. A different approach that you can try is SSIS: How to load multiple excel files into multiple SQL tables?

    Hi Vikash,

    I'm not sure that fine method will work for folks using 64 bit machines (which has become the norm rather than the exception) because the Jet drivers supposedly don't work with the 64 bit machines. I believe you need to use the Ace drivers for 64 bit machines. Do you have a code example for that?

    Shifting gears a bit, your article has a date on it from Feb 2013 so it's a fairly recent article. Have you discovered a method to use the Jet drivers on 64 bit machines? If so, could you post how you pulled that off, please?

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