move file from one folder to another folder

Question

hi anyone please help me how to move a file from one folder to another folder using SSIS please send me link anyone

Shahriar Nikkhah · Answer

Is the solution working for you?

Shahriar Nikkhah · Answer

Check this link https://sqldataside.blogspot.ca/2018/04/looping-through-flat-files-using-ssis.html just remove the DFT from the loop,

Piyush Pansuriya · Answer

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.

Piyush Pansuriya · Answer

Hello, Do you want to Move the file or Copy the file? Move Perform as Cut - Paste and Copy File Perform as Copy - Paste.

Piyush Pansuriya · Answer

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

Amudhan Kuppan · Answer

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 Kuppan · Answer

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

Amudhan Kuppan · Answer

yes its working

Amudhan Kuppan · Answer

ok Shahriar

Amudhan Kuppan · Answer

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

move file from one folder to another folder

Answers (10)