Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nsbv
Starting Member
2 Posts |
 Posted - 2008-10-22 : 02:21:44
|
| I want to copy a file from the network location using the script task. I want to pass user id and password to access the network connection.As of now i am using a batch file to do this task. But i want to get rid of this and add it in script task. Can anyone help me. |
|
|
rgombina
Constraint Violating Yak Guru
319 Posts |
Posted - 2008-10-22 : 08:48:54
|
| Using File System Task is much simpler than Script Task unless you really need this method. Also, passing/embedding network logon is security risk so why not having Sys admin allow servers to talk to each other. Just a thought... |
 |
|
|
nsbv
Starting Member
2 Posts |
Posted - 2008-10-22 : 18:48:15
|
quote:
Originally posted by rgombina
Using File System Task is much simpler than Script Task unless you really need this method. Also, passing/embedding network logon is security risk so why not having Sys admin allow servers to talk to each other. Just a thought...
As far as i know File System Task is not capable of doing user authentication. And we want to make this task generic so that i can use this task for all file copy operation from network path. |
|
|
|
|
|
|
script task to copy the file