How to copy a excel file to Destination server while copying DTS package to
different server?

--
Message posted via http://www.sqlmonster.com

There is no way to do this through the fact that you are copying a DTS
package.

I am presuming you want to do this so that when the package runs on the
remote server it will still find the XL spreadsheet in the same place
inrelation to the remote server as it did locally???

Try to configure your files to use UNC paths or use the Dynamic
properties task to set the path at runtime



"Sanjeev Dharwadkar via SQLMonster.com" <forum (AT) SQLMonster (DOT) com> wrote in
message news:forum (AT) SQLMonster (DOT) com: