Assignment: You are give a task where you have some files--> *.csv, *.txt, or any other file. You are asked to rename the files and move to same folder or different folder. How would you do this.
Lets look at what we are asked to do.
1. We have a Source Folder where we have files of a particular type. So we need to know the location of this folder. Lets create a variable called SourceFolder of string type and save location into this folder. let's assume that this is C:\temp\SourceFolder
2. We need to rename these files and save it in same folder location or different folder location and change name of these files. So let's create another variable and call them DestinationFolder of string type and save the location in value.
3. Now we need to pull each file in SourceFolder and put in them in Destination folder. Lets create a variable called FileName of string type and leave value blank. Also create two more variables called FullSourceFolderFileName and FullDestinationFolderFileName. FullSourceFolderName value would be @SourceFolder + @FileName and FullDestinationFolderFileName value would be @DestinationFolder + @FileName. The reason for creating these two variable is to be used at run time to dynamically use them in Foreach Loop Container.
So far we have following variable in our package
VariableName type Value
1.FullName string No value --- leave this blank
2.SourceFolder string C:\temp\SourceFolder
3.DestinationFolder string C:\temp\SourceFolder or C:\temp\DestinationFolder (you can dump renamed file in same source folder or dump into destination folder)
4. FullSourceFolderName string set expression to true and in expression put @SourceFolder + @FileName
5. FullDestinationFolderFileName string @DestinationFolder + @FileName same for this as you did for variable 4.
Now let's drop Foreach Loop in our package and configure it.
Now drop file system task and configure as show in figure below.
Now you are good to run the package.
