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

    To expand on the excellent suggestions of Markus:

    you can use the /SET option of DTEXEC to set the variables.

    Keep in mind if you call DTEXEC on another machine, the package will be executed on that machine. So this machine must have access to the network drive.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP