开发者

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


  1. Use for_each_folder_enumeration technology from here: http://microsoft-ssis.blogspot.com/2011/01/foreach-folder-enumerator.html

  2. Analyze folder name using Script component

  3. Check if folder is empty using Microsoft suggestion: http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/a3240e00-ac9d-4082-b1e4-72bd7f695524/

  4. Move folder using File System Task (Copy directory)

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜