I have a situation from where I need to loop through different folders and files in these folders. After processing these files, I need to archive these folders to different location.
e.g., C:\MainFolder\Mar01 ==> Multiple files in Mar01 folder
C:\MainFolder\Mar02 ==> Multiple files in Mar02 folder
Does any one know the best way to do this in SSIS?
Thanks in advance.
BC
One way would be a For Each Loop container with Traverse subfolders enabled, with a File System task inside it to move the files once they've been processed.
No comments:
Post a Comment