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 |
|
Hommer
Aged Yak Warrior
808 Posts |
 Posted - 2013-04-19 : 14:33:19
|
| Hi,I need your help on a solution that will have password protected UNC path as the destination for my ssis package.The unix admin gave me a pair of account name and password to that location.I couldn't even run from BIRD under my windows account. All the helps I found are about how to setup agent/proxies, etc. Thanks! |
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2013-04-23 : 21:09:33
|
| maybe use winscp?<><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-04-24 : 01:28:53
|
| you can use tool like what yosiaz suggested and use execute process task to ivoke it. reg. WinSCP you need a script file which will have details on server (ip address) username password port etc. i've written a blog on that so you can refer this for more details on how to use it. the password, username etc can be identified as configurable items and passed from outside.see below link for more detailshttp://visakhm.blogspot.com/2012/12/implementing-dynamic-secure-ftp-process.html------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2013-04-26 : 15:27:00
|
| Thanks!The destination turned out to be a windows. But your blog certainly will be handy in the future. Thanks!!! |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-04-29 : 00:48:55
|
| Welcome------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
how to output flat file to a secured unix loc?