Advertisement

07.08.2008 at 10:48AM PDT, ID: 23547569
[x]
Attachment Details

Run command line SFTP from SSIS

Asked by fesnyng in SQL Server 2005, Encryption for Network Security, Open Source Programming

Tags: Microsoft, Sql Server Integrations Services, 2005 SP2, SSIS and SFTP

I have a need to run SFTP (SSH FTP),  Admin likes psftp (type "putty" at the Google prompt.  First choice).

Seems simple enough.  Use the Execute Process Task to execute psftp.exe and pass in the parameters (including a batch file).  I've done this with other command line programs.  Almost like stealling.  And, sftp works beautifully from a command line at the DOS prompt.   Should be no problem.

Here's the kicker:   Execute Process Task will NOT run psftp.exe IF ANY parameters are passed.  ANY parameters. Even if I encapsulate psftp.exe inside a .bat file, the Task fails if any parameters are passed. I have tried the following:

0.  psftp -V     successful at DOS prompt from any folder (i.e. PATH is not an issue). (returns version)
1.  psftp         successful from Execute Process Task (note: no params)
2.  psftp AND parameter -V     FAILS with Execute Process Task
3.  psftp (no params) inside a .bat file   successful from DOS prompt and from Execute Process Task
3.  psftp -V inside a .bat file  succesful from DOS prompt
4.  psftp -V inside a .bat file    FAILS with Execute Process Task
5.  notepad.exe test.txt   successful from Execute Process Task

It seems that Execute Process Task works with any program except psftp.exe.   Is there any way to get psftp.exe to run?

HELP!    :-)

THANK YOU FOR ANY ASSISTANCE.Start Free Trial
[+][-]07.08.2008 at 12:14PM PDT, ID: 21957069

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.09.2008 at 10:16AM PDT, ID: 21965994

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: SQL Server 2005, Encryption for Network Security, Open Source Programming
Tags: Microsoft, Sql Server Integrations Services, 2005 SP2, SSIS and SFTP
Sign Up Now!
Solution Provided By: mark_wills
Participating Experts: 1
Solution Grade: A
 
 
[+][-]07.09.2008 at 04:26PM PDT, ID: 21969273

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.09.2008 at 04:30PM PDT, ID: 21969287

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628