move file from one folder to another folder

Amudhan Kuppan

8y951

anyone please help me

how to move a file from one folder to another folder using SSIS

please send me link anyone

10 Replies

Know the answer? Post it — somebody with the same question will find it here.

Shahriar Nikkhah8y ago
Accepted answer
Is the solution working for you?
Amudhan Kuppan8y ago
yes its working
Amudhan Kuppan8y ago
ok
Shahriar
Shahriar Nikkhah8y ago
Check this link

https://sqldataside.blogspot.ca/2018/04/looping-through-flat-files-using-ssis.html

just remove the DFT from the loop,
Piyush Pansuriya8y ago
Hello,
As per your requirement, Move File in operation is use only.
But it is copy the file from source to destination. as a copy file.
So, there is no diffrenece between move file and copy file.

So, as a solution, after this task add deletion task to delete file from souce folder.
Amudhan Kuppan8y ago
how to create SSIS Parameter and once the file processed it will be shift in another folder.
(ie) how to move a file from source to destination folder
I need after iam package execution it contain a file only in destination folder not contain a source folder please send me a link
Amudhan Kuppan8y ago
move the file piyush already iam using but now iam forgotten iam using for each loop container and file system task and link is www.techbrothersit.com
Piyush Pansuriya8y ago
Hello,
Do you want to Move the file or Copy the file?
Move Perform as Cut - Paste and Copy File Perform as Copy - Paste.
Amudhan Kuppan8y ago
piyush this is ok iam ask move a file from source to destination but this is contain move a file from one folder to another folder that is after iam run the package it contain a file both folder also i need move a file from source to destination after iam running the package it contain a file only in destination folder ok please send me link
Piyush Pansuriya8y ago
Hello,

Please go through the below link:
https://www.tutorialgateway.org/move-file-using-file-system-task-in-ssis/

https://www.tutorialgateway.org/move-multiple-files-using-file-system-task-in-ssis/

https://www.youtube.com/watch?v=SXK7N6r7Wnc