September 16, 2010 at 1:30 am
I need to delete files and more importantly the folders containing the files which are older than 90 days.
Can this be done with a SSIS package
I can delete the files with a for each loop container but not the folders.
Is it possible to delete all the subfolders and files in the subfolders which are older than 90 days through SSIS?
September 16, 2010 at 1:49 am
What happens when you have new files in older folders?
Better approach for the folders would probably be to delete them if they're empty.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
September 16, 2010 at 3:25 am
anuragingle (9/16/2010)
I need to delete files and more importantly the folders containing the files which are older than 90 days.Can this be done with a SSIS package
I can delete the files with a for each loop container but not the folders.
Is it possible to delete all the subfolders and files in the subfolders which are older than 90 days through SSIS?
I would vote for archiving the old content periodically by storing the archived content at a seperate location and then deleteing the Directory content of the archived folder:-D:cool::-)
Raunak J
September 16, 2010 at 12:28 pm
got the solution
just named the folders with the current date and use rmdir command
September 17, 2010 at 10:44 pm
anuragingle (9/16/2010)
got the solutionjust named the folders with the current date and use rmdir command
Anurag,
Great job!!!
But still follow a framework approach while implementing and architeting an enterprise solution
Raunak J
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply