Home Forums SQL Server 2005 SQL Server 2005 Integration Services Moving files from one folder to another folder RE: Moving files from one folder to another folder

  • October 16, 2012 at 6:01 am

    #1549497

    sqlstud (10/16/2012)

    Hi,

    I have one folder with two files

    C:\Pkg\28052012_sample.xlsx

    C:\Pkg\29052012_sample.xlsx

    Using SSIS 2005 i have loaded the data from the above xlsx file using For each loop container.

    Query:

    Need to move the file to D:\Archive, after the package successfuly loaded the data.

    Could you please let me know the steps?

    Regards

    Sqlstud

    Regards

    Sqlstud

    Thanks Henrico..

    I need to move only after the successful loading.....