| Author |
Topic |
|
inbs
Aged Yak Warrior
860 Posts |
 Posted - 2009-11-11 : 05:31:19
|
| how can i add this to ssis: (i dont save it as .bat)net use x: \\PDTG\c$\Stap /y /USER:MyUser MyPass /PERSISTENT:YES |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-11-11 : 10:05:53
|
| Add an Execute Process task to your package.BUT...this is a bad idea. Just use unc path instead of mapped drives |
 |
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2009-11-11 : 11:22:41
|
| what is unc? |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-11-11 : 11:28:03
|
unc is like this:\\server\shared_folder
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2009-11-11 : 12:57:10
|
| ohh,ok.but in Execute Process task .in executable i must choose a file(filename.bat), i try to write this line in executable ,but i get error.can i use Execute Process task without choose a file?? |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-11-11 : 12:59:48
|
| why are you mapping a drive? this is a future error waiting to happen. |
|
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2009-11-11 : 13:18:57
|
| sorry but i dont understand you? i must to map a drive,otherwise hoew is he know where to get the files?i save it in a file and it is run, but i dont want use a file,do i have another way with Execute Process task component? |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-11-11 : 14:36:43
|
| have it get the file from \\PDTG\c$\Stap |
|
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2009-11-11 : 15:38:34
|
| if i write \\PDTG\c$\Stap ,so it asked me for user and password.i want to write it in component,but i dont where. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-11-11 : 16:54:51
|
| need to give the sql agent account permission on that share |
|
|
|
|
can it run in ssis