transfering files from an sftp site
-
Good evening guys, i want to transfer some flat files from an fstp site that i set up.
server name: "nik.vix.com"
username: klinevix
password:@23$~jack
can u guys show how to do this in ssis with code inclusive, any help is appreciated
-
You can make use of the FTP Task. Here[/url] is an example.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga -
If you meant SFTP, SSIS does not support this. I had to call third party software (PSFTP, the PuTTY SFTP client) from the SSIS package after I generated the script from a C# script task. Was a pain to set-up.
-
SSIS FTP object doesn't do SFTP, as already mentioned.
I used WinSCP for this when I had to do it a little while back. They actually have a documentation page on how to use their product in SSIS, on their web page.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
-
klineandking (11/14/2010)
Good evening guys, i want to transfer some flat files from an fstp site that i set up.server name: "nik.vix.com"
username: klinevix
password:@23$~jack
can u guys show how to do this in ssis with code inclusive, any help is appreciated
If you can use third-party solutions, check the commercial CozyRoc SFTP Task. It supports both SSH and FTPS protocols.
---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply