question

vs0523 avatar image
vs0523 asked

SSIS Looping through filenames and moving them

Hello everyone I have a table where there are names of the files in a column. I have a master folder location where the files are located. My requirement is to move find the files and move them to a target folder. Issue here in my requirement is , that I don't know the exact location of the file. These files might be any any of the subfolders under the master file. Could anyone please help me. Thanks in Advance.
ssisfile locationmove-rename
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

JohnM avatar image JohnM commented ·
Could you not just use a ForEach container loop and iterate through the sub-folders? Do all of the files get consumed or just certain ones?
0 Likes 0 ·
vs0523 avatar image
vs0523 answered
I thought of For each loop . But it is only certain files that I need not all of them . Not sure how to approach on certain files that I need to find in folders. Thanks.
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

JohnM avatar image JohnM commented ·
Can you filter by name or extension?
0 Likes 0 ·
vs0523 avatar image vs0523 commented ·
No. I do not need all the files with that extension or name. For example I have one file with abc.pdf and other file with Newyork.pdf to be moved to certain folder. And I have like 30,000 files to be moved to other folder. And I have all the names of the files stored in a table. Thanks.
0 Likes 0 ·
Lukasz8519 avatar image
Lukasz8519 answered
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.