Using SSIS to Archive access databases

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Business Intelligence » Using SSIS to Archive access databases

Using SSIS to Archive access databases

Rate Topic

Display Mode

Topic Options

Author

Message

Trybbe

Posted Thursday, December 20, 2012 12:48 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 7:04 AM
Points: 169, Visits: 433

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

Post #1398834

Koen Verbeeck

Posted Thursday, December 20, 2012 3:47 AM

SSCrazy Eights

Group: General Forum Members
Last Login: 2 days ago @ 2:11 AM
Points: 9,378, Visits: 6,473

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

How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence

Post #1398889

Trybbe

Posted Friday, December 21, 2012 12:57 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 7:04 AM
Points: 169, Visits: 433

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

Post #1399234

« Prev Topic | Next Topic »

Permissions