SFTP through SSIS

Question

SFTP through SSIS

qhjghz

Mr or Mrs. 500

Points: 547
More actions
January 7, 2009 at 12:12 am

#126335

Hi,
I require to do a SFTP through SSIS. I have used WINSCP for this purpose. I have used the command-line utility for WINSCP and am able to upload the file properly. But, I want the path to be uploaded to be a variable one and not a fixed one. Is it possible to pass a user input to the WINSCP command line script? if possible, can anyone please share the script?

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

COZYROC One Orange Chip Points: 28499 More actions · Answer 1

qhjghz (1/7/2009)
Hi,
I require to do a SFTP through SSIS. I have used WINSCP for this purpose. I have used the command-line utility for WINSCP and am able to upload the file properly. But, I want the path to be uploaded to be a variable one and not a fixed one. Is it possible to pass a user input to the WINSCP command line script? if possible, can anyone please share the script?

In the Execute Process Task, you have to setup SSIS expression for the process argument. You can setup the expressions by right-clicking on the task and selecting Properties. Scroll-down and find Expressions. Setup expression for your argument there.

You may also consider the SFTP Task. It is commercial, but it is much better integrated with SSIS.

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

sacha.bessard Old Hand Points: 370 More actions · Answer 2

http://www.xoowiki.com/Article/SQL-Server/ssis-acces-sftp-475.aspx

Stan Kulp-439977 SSChampion Points: 10062 More actions · Answer 3

You can use the open source SSIS SFTP custom task component from this project at CodePlex.com

http://ssisextensions.codeplex.com/

Here is the 2008 R2 version:

http://ssisextensions.codeplex.com/releases/view/101949

Here is the 2012 version:

http://ssisextensions.codeplex.com/releases/view/101332

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 4

Stan Kulp-439977 (10/18/2013)

You can use the open source SSIS SFTP custom task component from this project at CodePlex.com

http://ssisextensions.codeplex.com/

Here is the 2008 R2 version:

http://ssisextensions.codeplex.com/releases/view/101949

Here is the 2012 version:

http://ssisextensions.codeplex.com/releases/view/101332%5B/quote%5D

Let's make this easier for others:

You can use the open source SSIS SFTP custom task component from this project at CodePlex.com

http://ssisextensions.codeplex.com/

Here is the 2008 R2 version:

http://ssisextensions.codeplex.com/releases/view/101949

Here is the 2012 version:

http://ssisextensions.codeplex.com/releases/view/101332

benjamin.reyes SSCertifiable Points: 5249 More actions · Answer 5

[font="Arial"]I adopted a legacy log shipping setup that was sent over sftp using a combination of SSIS, putty, Sqb2mtf, a series of stored procs, and several configuration/logging tables.

It was mostly broken when I inherited it and spent a good amount of time getting it working and performing well considering the vendor and our internal requirements.

Sorry I don't have any code handy, but I can highly recommend Bitvise Tunnelier vs any of the other sftp options I tested. It's easily scripted and about as fast as sftp gets for Windows.

Why not handle the variables in T-sql, powershell,vb , pearl or python?

[/font]

Abbas-418434 Grasshopper Points: 18 More actions · Answer 6

hi

do you have a sample code on how to use BitVise with SSIS?

Thanks

Stan Kulp-439977 SSChampion Points: 10062 More actions · Answer 7

I haven't touched this subject for years.

I did google this, however.

https://www.mssqltips.com/sqlservertip/4025/sftp-in-sql-server-integration-services-ssis-package-with-bitvise/