locked
Move Files from source to destination after renaming RRS feed

  • Question

  • Hi,
    Please help me do this task

    I have a source folder D:\Source  with 'n' files of type .txt,.pdf,.xls and so on (mixture of all types)

    I need to move these files to D:\Destination by appending date at the end of the files.

    How do i do this with SSIS File System task? Or is there any other way to go about this?

    Tuesday, January 24, 2012 11:44 AM

Answers

  • Hi, you can do it using File System task or Script task.

    Check these links:

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

    http://consultingblogs.emc.com/jamiethomson/archive/2005/09/14/SSIS-Nugget_3A00_-Move-and-rename-a-file-in-one-operation.aspx

    David.

    • Proposed as answer by Eswararao C Tuesday, January 24, 2012 12:18 PM
    • Marked as answer by Eileen Zhao Monday, February 6, 2012 2:52 AM
    Tuesday, January 24, 2012 11:52 AM

All replies

  • Hi, you can do it using File System task or Script task.

    Check these links:

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

    http://consultingblogs.emc.com/jamiethomson/archive/2005/09/14/SSIS-Nugget_3A00_-Move-and-rename-a-file-in-one-operation.aspx

    David.

    • Proposed as answer by Eswararao C Tuesday, January 24, 2012 12:18 PM
    • Marked as answer by Eileen Zhao Monday, February 6, 2012 2:52 AM
    Tuesday, January 24, 2012 11:52 AM
  • Hi,

    You can create file system task and then use variable to carry the name of each file and another variable to hold date and a suitable format.

    These file system task must be on the foreach loop.

     

    I hope this is helpful.

     

    Elmozamil Elamir

    MyBlog


    Please Mark it as Answered if it answered your question
    OR mark it as Helpful if it help you to solve your problem
    Elmozamil Elamir Hamid
    http://elmozamil.blogspot.com
    Tuesday, January 24, 2012 1:01 PM