i want to create a package to rename the mulitple files filename when the files is came in a schedule time when i creating the three variables SourceFile (directory) and FilePath (File) and FileExten (fileType) in this filepath is not recognizing files in the folder when i running the task please suggest me how to rectify thisSandeep Kumar

Hi Sandeep, What is your approach? Script TaskFor Each Loop with File System Task If other, can you elaborate more?Please vote as helpful or mark as answer, if it helps Cheers, Raunak | t: @raunakjhawar | My Blog

Here is a step-by-step procedure to do this.... http://www.rafael-salas.com/2007/03/ssis-file-system-task-move-and-rename.html#!/2007/03/ssis-file-system-task-move-and-rename.htmlHTH, Cheers!! Ashish Please mark it as Answered if it answered your question or mark it as Helpful if it helped you solve your problem.

script task why because the file will download from ftp server in a schedule time in that the package will be run and any way send me the for eachloop with filesystem task if u have any suggestions please thanks sandeep kumarSandeep Kumar

use this concept to build a expression. http://www.bidn.com/blogs/KeithHyer/bidn-blog/1081/expressions-build-a-filename-variable-in-ssis put into the loop to create or rename the file. Regards, Chirag Patel (ETL Engineer)