Post reply

Using SSIS to Archive access databases

  • December 20, 2012 at 12:48 am

    #286639

    Hi I have a lot of .mdb (ms access) files that I need to compact and archive and I'm strugling with the for each loop container. it does not traverse through subfolders, just keeps picking up the same file.

    please assist

  • December 20, 2012 at 3:47 am

    #1570474

    In the For Each Loop, there's a checkbox "Traverse subfolders" (if the For Each File enumerator is selected). Is it checked?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • December 21, 2012 at 12:57 am

    #1570760

    Hi, Thanks for the response. I ticked traverse but it's still not picking the other file. now I'm trying to use a variable as a place holder for the file name but I'm still not getting that right

Viewing 3 posts - 1 through 2 (of 2 total)

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