Tutorial - How to Rename and Archive Files via SSIS

[@itsallmakebelieve9151]

That's beautiful man, thank you. Haven't done any SSIS for a while so it really helps get things moving for my project.

[@steverowden7125]

Well done video and easy to follow, especially for someone new to SSIS.

[@dougstiers6154]

Nice work Mohamed, thank you.

[@StephenRybacki]

Excellent explanation. Thanks!

[@nurhakkarakaya4332]

It is so good and clear.

[@williamleandro5300]

Congratulations Men!

[@frankdo8845]

hi, i keep getting error on the Rename step: Variable "NewFilePath" is used as a source or Destination and is empty. Can you help please. Thank you.

[@msk2982]

Did you put in anything in the newfilepath variable?

[@frankdo8845]

i think I know why .. I did not use the Foreach Loop container. Because I only have 1 file to archive and I thought I did not need a loop. In another word, you can't have the "File System task" by themselves but must be inside the Foreach loop. Please let me know if that's true. Tky.

[@msk2982]

​@@frankdo8845 You should be able to use any task without the for each loop. The loop is there just to run a set of tasks multiple times. I actually running the task process without the loop to make sure it's working, then put it inside the loop later. Make sure you have some kind of string value in your NewFilePath variable. Watch this video as well kzbin.info/www/bejne/h3jHlIaXfpaHeMk

[@nehashahpatel1741]

millions thanks

[@salurbano3814]

Hi This video is very good but I don't quite understand how you were able to move all the files since they all had different names. In your video you specified file Project_B.xls. How did the other files Project_C, Project_D etc get renamed and moved.

[@msk2982]

Hey Sal great question. You need to create a variable for the filenames. I went over it in my other video starting here: kzbin.info/www/bejne/h3jHlIaXfpaHeMk . This video is more of an addition to that one. Let me know if you still have any questions.

[@salurbano3814]

Hi Mohamed, My problem is that I have various files exp. RCA1_20180606.2834.txt, RCA1_20180606_2835.txt, PS01_20180606_3000.txt etc. I need to rename just the files that begin with RCA1 to RCA4. exp RCA1_20180606.2834.txt to RCA4_20180606.2834.txt.I have a ForEach Loop and in it I have a File System task.I assigned a FilePath variable that has the full directory name along with a filename. The package works, but it just changes the name of the file specified in the FilePath variable. How can I change the file names for all files that begin with RCA1?

[@jamesdinser4411]

I duplicated what you have and it only renames one file.

[@narendrachitra5865]

excellent

[@harveywang1395]

Great walkthrough, thanks a lot

[@msk2982]

Glad it was helpful!