• Since, the path of the source and destination is different, you have to opt .. package configuration wizard to create XML configuration.

    Using DTSconfig option you can deploy your package as a file system one or in sql server.

    Regards,

    Venkatesan prabu .J

    Thanks and Regards,
    Venkatesan Prabu, 😛
    My Blog:

    http://venkattechnicalblog.blogspot.com/