I need to copy a file on another Windows server using a predefined UserAccount.
Is there a way to do this in DTS?
I don't believe I can use the FSO because it would not be connecting with
the correct user account.

I tried using a Text File connection to/from with a transformation in the
middle.
This way I can specify the user account to use.
The transformation unfortunately puts "" and , in the file which I don't
want. Doesn't seem to be a way to get rid of them, The datatransform option
page doesn't seem to work.
thanks,

Chuck

Rcp command is one option. See Windows Help. Another option is to create a
mapped drive for the required user with the NET USE command.

Ilya

"Chuck P" <nospam (AT) crlf (DOT) com> wrote

Can't use rcp because of security policies.
I don't know how to use net use within DTS.


"Ilya Margolin" wrote:

Chuck,

Create a batch file with three lines. One for deleting a mapped drive, one
for creating a brand new mapped drive, and one to exit with 0 exit code.
Below is an example:

net use N: /d
net use N: "\\Server\Share" /user:[domainname\]username /persistent:no
exit 0

Use Execute Process task to execute the batch file before using the mapped
drive. It will be accessible while package is running.

Ilya

"Chuck P" <nospam (AT) crlf (DOT) com> wrote