使用文件系统任务移动和重命名文件结束日期部分 [英] Move and Rename File end with date part using with File System Task

问题描述

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

推荐答案

你可以参考这个博客，它已经显示了整个方法，请参考...





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



让m我知道你是否还有任何困难..



问候，

Mubin Shaikh

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

这篇关于使用文件系统任务移动和重命名文件结束日期部分的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！