Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Using SSIS to Archive access databases Expand / Collapse
Author
Message
Posted Thursday, December 20, 2012 12:48 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, August 4, 2014 11:24 PM
Points: 176, Visits: 482
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
Posted Thursday, December 20, 2012 3:47 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 8:55 AM
Points: 13,570, Visits: 11,383
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
Posted Friday, December 21, 2012 12:57 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, August 4, 2014 11:24 PM
Points: 176, Visits: 482
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 »

Add to briefcase

Permissions Expand / Collapse