SSIS - how to move all the file start with AB_*.xlsx to another folder

Question

SSIS - how to move all the file start with AB_*.xlsx to another folder

nononame2021 261

my SSIS is generated multiple file, filename starting with "AB_.xlsx" to C:\Output folder.
how can i add a task to move all the file starting with "AB_.xlsx" from C:\Output to C:\Project folder ?

any sample for my referene.

2 answers

Your answer

Answer 1

ZoeHui-MSFT 41,496

Hi @nononame2021 ,

The issue is same as this which also raised by you.

Just edit the collection Foreach Loop Container with AB_.xlsx.

Regards，

Zoe

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

ZoeHui-MSFT 41,496 Reputation points

2022-07-06T02:28:01.227+00:00

Do you have further question on this , could we offer more support?
If this helps on your issue, you could mark it as answer so other user with similar problem could see this easier. :)
nononame2021 261 Reputation points

2022-07-06T02:56:37.28+00:00

i have the following files in the C:\Output , how to move only file name starting with AB_*.xlsx to C:\Project folder, only set the AB_.xlsx in file name is okay?
i don't know the setup, how about the file system task inside the forloop container. could you show me the full solution?

AB_20220601.xlsx
AB_20220602.xlsx
AB_20220603.xlsx
CB_20220601.xlsx
ZoeHui-MSFT 41,496 Reputation points

2022-07-06T06:50:00.42+00:00

Have you check this? ssis-move-all-the-filenames-start-with-specific-wo.html
And then refer to below settings.
You may also follow this tutorial. move-multiple-files-using-file-system-task-in-ssis
ZoeHui-MSFT 41,496 Reputation points

2022-07-08T08:50:29.503+00:00

Do you have further question on this , could we offer more support?
If this helps on your issue, you could mark it as answer so other user with similar problem could see this easier. :)

Answer 2

Olaf Helper 47,516

Use a ForEach enumeration to get all matching file names
https://learn.microsoft.com/en-us/sql/integration-services/control-flow/foreach-loop-container?view=sql-server-ver16
and then use inside the ForEach a File System task to move the files
https://learn.microsoft.com/en-us/sql/integration-services/control-flow/file-system-task?view=sql-server-ver16

Share via

SSIS - how to move all the file start with AB_*.xlsx to another folder

2 answers

Your answer