Click here to Skip to main content
14,839,837 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
CSS
Hello Everyone,

Please anyone help me to sort out this. I need to rename the excel file name and move to another folder.

or move to another folder and rename the files.

As example, i am looking output like this

Source Folder: c:\Temp\source

and source files: 1.emp.xls, 2.student.xls, 3.university.xls

output should be like thisdestination folder: c:\Temp\Dest

and files like: 1.emp_20130506.xls, 2.student_20130506.xls and 3.university_20130506.xls


Thanks In Advance

Anil
Posted
Updated 14-Jan-21 9:08am

1 solution

Hi,

You can refer this blog it has shown entire method to do this please refer...


REF1:
http://www.rafael-salas.com/2007/03/ssis-file-system-task-move-and-rename.html#!/2007/03/ssis-file-system-task-move-and-rename.html

REF2:
http://www.bidn.com/blogs/KeithHyer/bidn-blog/2465/copy-and-rename-a-file-in-ssis-using-the-file-system-task

let me know if you still have any difficulty..

Regards,
Mubin Shaikh
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900