sql server dts: Filecopy Denied -- sql server dts

Re: Filecopy Denied

Sue Hoegemeier
6/20/2007 10:49:03 PM

sql server dts: You could execute a net use command to map a drive, supply a
user name and password for the connection to the mapped
drive, copy the file, delete the mapped drive.

-Sue

On Thu, 21 Jun 2007 04:08:44 -0000, Peps
[quoted text, click to view]

Filecopy Denied

Peps
6/21/2007 4:08:44 AM

I have a job that needs to copy a file from a network share to the
local server. I'm using a FilesystemObject.Filecopy script and it
works ok when executed under my admin account that has access to the
network share. The problem I'm encountering is when I schedule the
job.

SQL (2K) is running under a Local Account and I understand how this
can fail since the (local) account does not have credentials in
accessing the network share. How can I get around this? Is it possible
to specify a userid/password in my script? Please help!

Thanks much!

Re: Filecopy Denied

Merwin O. Pingul
6/22/2007 12:00:00 AM

Use a proxy on Jobs that will help then make it sure that the file IO must
have your credential

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server dts group.