question

kkran-5951 avatar image
0 Votes"
kkran-5951 asked EchoLiu-msft commented

File System task : Move files and delete files in source folder

Hello Everyone :

Hello Team - How do I move files from Folder A to Folder B and Folder C through the SSIS File System task?

Visual Studio 2013

Folder A: C:\FTP\Main\FolderA
Folder B: C:\Staging\Local\FolderB
Folder C: C:\Staging\Local\FolderC

Folder A is the main path where I get the files (25 files a day) from clients on daily basis.
I need to move files from Folder A to two folders (Folder B and Folder C) on the daily basis and want to delete the files from folder A once copied to Folder B and C.

Thanks in Advance

sql-server-transact-sqlsql-server-integration-services
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Could you have any update?Did the following methods solve your problem?If not, please provide more details.If it is resolved,please also remember to accept the answers if they helped. Your action would be helpful to other users who encounter the same issue and read this thread.

0 Votes 0 ·

1 Answer

EchoLiu-msft avatar image
0 Votes"
EchoLiu-msft answered EchoLiu-msft commented

Hi @kkran-5951

Do you have any questions about which steps to move files? I found a complete example for you.

Please refer to:
Move File Using File System Task in SSIS

There are detailed steps for moving files in the above article,if you have any question, please feel free to let me know.


Regards
Echo


If the answer is helpful, please click "Accept Answer" and upvote it.


· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

[File System Task] Error: An error occurred with the following error message: "Could not find file '\C:\FTP\Main\FolderA\'.".

This is the error I am getting. I have about 50 PDF files in this folder.

Variables:
uTargetFileStagingPath | String | C:\FTP\Main\FolderA\

uTargetFilePathOne | String | C:\Staging\Local\FolderB\

Should i write a use for each loop task?

0 Votes 0 ·

I figured the answer. I have to use for loop.

0 Votes 0 ·

Glad your problem is solved!

0 Votes 0 ·