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 |
|
mohanndl
Starting Member
2 Posts |
 Posted - 2008-12-08 : 18:26:51
|
| Hi all,I have to create one package that will extract files and loading into FTP ,if FTP ip not found we have load into windows file share folder.FTP part is working fine but how to load to windows file share folder(That will ask username and password and UNC format).Thnaks in advanceMohan |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2008-12-12 : 11:06:34
|
| You can create a mapped drive to network share using a domain users credentials. So no prompting for password etc.You can do this with batch file or running following with xp_cmdshell.net use t: \\server\share /user:domain\user passwordcopy "C:\temp\test.txt" "t:\temp"net use /delete t: /Y |
 |
|
|
|
|
|
FTP and windows file share