• MarkusB (9/6/2013)


    I hope I get it right now.

    Create your package with two "file system tasks" connect them with an "on success" connection.

    Then define a variable "sourcepath" and change the sourceconnection properties. Use an expression which refers to your variable.

    If necessary do the same for the destination.

    To run the package from another machine use dtexec.exe.

    That was Great.

    need another help.

    now, my destination has the files. and with time it will start increasing.

    what is want is, to delete all the files from that folder which are older than 7 days.