Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SFTP through SSIS Expand / Collapse
Author
Message
Posted Wednesday, January 7, 2009 12:12 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, November 18, 2009 12:00 AM
Points: 11, Visits: 57
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?
Post #631218
Posted Wednesday, January 7, 2009 7:17 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, July 9, 2014 5:27 PM
Points: 1,117, Visits: 2,219
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/

Post #631434
Posted Thursday, November 19, 2009 5:40 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, October 25, 2011 2:59 AM
Points: 8, Visits: 55
http://www.xoowiki.com/Article/SQL-Server/ssis-acces-sftp-475.aspx
Post #822032
Posted Friday, October 18, 2013 7:35 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 10:07 AM
Points: 124, Visits: 890
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
Post #1506351
Posted Saturday, October 19, 2013 5:52 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 12:58 PM
Points: 23,009, Visits: 31,504
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


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



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1506387
Posted Monday, October 21, 2013 3:39 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 11:04 AM
Points: 252, Visits: 1,355
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?
Post #1506892
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse