102 How to rename a file in script task using SSIS 

Thanks for appreciation.

You are most welcome.

Never Mind I have achieved this using C# scripts.

Why do it like that? Why not just not just link the spreadsheet to your SSIS package, then simply skip the first 12 columns?... The Excel spreadsheet can be linked using an Excel ODBC connection and then processed as is.

yes we can append the current date time as well while moving the file. Below code can actually move all files from source folder to destination folder and while moving it can append current date time to the moved file try { //Provider Source Folder Path string SourceFolder = @"C:\Source\"; //Provide Destination Folder path string DestinationFolder = @"C:\Destination\"; //datetime variable to use as part of file name string datetime = DateTime.Now.ToString("yyyyMMddHHmmss"); var files = new DirectoryInfo(SourceFolder).GetFiles("*.*"); //Loop throught files and Move to destination folder foreach (FileInfo file in files) { string fileExt = ""; fileExt = Path.GetExtension(file.Name); //Move the file to destination folder after adding datetime file.MoveTo(DestinationFolder + file.Name.Replace(fileExt,"") + "_" + datetime + fileExt); } } catch(IOException Exception) { Console.Write(Exception); } }

Thanks@@learnssis

You are most welcome.

@@learnssis thank you sir

@@kichuchinnu3303 You are most welcome.

If you want to do it for multiple files then put this script task inside the foreach loop container, then script task will run for each file in the source folder and you can pass the file path using the same ssis variable that we used in this video.

@@learnssis not the multiple files but i have to change the same file name each time package runs. For that also do i have to use for eachloop?

@@parulgupta2535 Foreach loop can be used to loop through either files in a folder or records in a sql table. if you want to get the file name from a folder then you can use a foreach loop container with file enumerator. And if you want to get the filename from sql table then you can use the foreach loop container with ado enumerator. If you want to pass the file name from SSIS variable or parameter then you don't need the foreach loop.

@@parulgupta2535 How you want to pass the filename to ssis package ?

You can use a foreach loop container with file enumerator and pass the file name using ssis variable to script task. If you want to see how to use foreach loop container with file enumerator then you can check that here ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-BjpaSxMZMxs.html and if you want to know how to pass the variable through script task then you can check it here ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-5XbMsdlQe04.html

Renaming can be done one file at a time. If you want to move for example all files in a folder or specific types of files, then you can use a foreach loop in C# to loop through files and rename one file at a time DirectoryInfo d = new DirectoryInfo(@"C:\DirectoryToAccess"); FileInfo[] infos = d.GetFiles(); foreach(FileInfo f in infos) { File.Move(f.FullName, f.FullName.Replace("abc_","")); // Careful!! This will replaces the text "abc_" anywhere in the path, including directory names. }

I have 4 files and I want to change only the name of each of the files.@@learnssis

Sorry I did not get it correctly, can you please give an example like abc.csv file will be renamed to which value ?