Post reply

Moving files from one folder to another folder

  • October 16, 2012 at 5:25 am

    #264333

    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

  • October 16, 2012 at 5:30 am

    #1549474

    I'd consider kicking of an executable batch job from ssis.

    ref: http://ask.metafilter.com/50369/How-to-move-files-into-subdirectories-in-batch-job

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • October 16, 2012 at 5:42 am

    #1549481

    Or you can use the File System Task built into SSIS.

    John

  • October 16, 2012 at 5:55 am

    #1549493

    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

    is it possible to rename the file after moved to destination folder

    Regards

    Sqlstud

  • October 16, 2012 at 5:59 am

    #1549495

    I'll let you find that out for yourself. Just type "File System Task" into your favourite search engine.

    John

  • 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.....

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply