SSIS delete folders named with a date
My process ceates automatically some new folders named with a date i.e (09-01-2011) in a directory (Archive) How can I check 开发者_开发知识库the date of the folder in the directory and delete those older than a certain date?
Thanks
Use for_each_folder_enumeration technology from here: http://microsoft-ssis.blogspot.com/2011/01/foreach-folder-enumerator.html
Analyze folder name using Script component
Check if folder is empty using Microsoft suggestion: http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/a3240e00-ac9d-4082-b1e4-72bd7f695524/
Move folder using File System Task (Copy directory)
精彩评论