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 |
|
jbates99
Constraint Violating Yak Guru
396 Posts |
 Posted - 2013-09-25 : 09:25:41
|
| I'm looking for a 3rd party tool that I can execute from my SSIS package to FTP files to a secured ftp site. Because I will have many files to send from several folders, it needs to be able to accept a parameter containing the file path each time it is called.I have WinSCP but I'm wondering if there is a better tool, one that I can pass a filename into. I appreciate any ideas.Thanks, Jack |
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2013-10-21 : 13:42:50
|
| how about using the default ftp task of SSIS? have you tried that?<><><><><><><><><><><><><><><><><>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-10-21 : 14:27:40
|
quote:
Originally posted by yosiasz
how about using the default ftp task of SSIS? have you tried that?<><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion
It doesnt support SFTP by default------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-10-21 : 14:28:54
|
quote:
Originally posted by jbates99
I'm looking for a 3rd party tool that I can execute from my SSIS package to FTP files to a secured ftp site. Because I will have many files to send from several folders, it needs to be able to accept a parameter containing the file path each time it is called.I have WinSCP but I'm wondering if there is a better tool, one that I can pass a filename into. I appreciate any ideas.Thanks, Jack
I too use WinSCP for thatThis is a blog which explains how I implemented it using SSIS passing dynamic parametershttp://visakhm.blogspot.in/2012/12/implementing-dynamic-secure-ftp-process.html------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
jbates99
Constraint Violating Yak Guru
396 Posts |
Posted - 2013-10-27 : 22:19:07
|
| Thanks for the replies and suggestions.WinSCP is working well for both uploading to and downloading from the SFTP site. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-10-28 : 07:00:06
|
| cool------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
Need Tool to FTP to SFTP Site