|
Comments
|
|
please provide a link to the psftp executable
|
|
|
Dav, here's a link to the PSFTP executable:
http://www.chiark.greenend.org.uk/~sgtatham/putty/download.html
|
|
|
thanks, great job
|
|
|
Good news flash ...
|
|
Gina Meronek on
7/14/2009
Very useful info!
|
|
Gina Meronek on
7/14/2009
Supporting code link does not work, however.
|
|
|
I really needed this. Thanks!
|
|
|
Fantastic
|
|
Jamshid Nouri on
7/14/2009
excellent demo
|
|
Mark Redfern on
7/15/2009
where do you get psftp from?
|
|
|
was good video
|
|
|
Mark, read above and the link is provided. :)
|
|
|
terrific, and straight-forward
|
|
|
Just curious, why can't you use the SSIS FTP task already in SQL Server 2005 & 2008 instead of your third party tool? It appears to do the same thing, plus the 2008 version allows you to run in passive mode too which deals with firewall filtering..
|
|
|
Very nice.
|
|
|
Very detailed explation of ftp process.
|
|
Tim Mitchell on
7/17/2009
Travis, you're correct that the FTP task in SSIS works very well, but it does not support SFTP (secure FTP) connections. This video demonstrates a workaround for that.
|
|
|
The commentator was a little quiet. I had the volume all the way up and had difficulty hearing him.
|
|
|
good video. nice job!
|
|
|
nice to know that
|
|
|
Great! I guess this works each time you need to run a program from shell, command line, command prompt, etc.
|
|
|
Can't believe people still complain even though going through from such a good demo. Grow up Kristeen
|
|
|
excellent !
|
|
|
If you want to get the output try calling "cmd.exe /c PSFTP.exe {PARAMETERS} > DirectoryOutput.txt" THis will allow you parse the remote dir and drop it in a database . Now add compare logic and determine if a file transfer is still in progress from the person dropping the file for you to pick up. Do this by grabbing list, wait 5-10 minutes, if file size changed, then file is still in progress, wait longer... If the drop is delayed have it send and email to your service provider telling them they have an SLA issue, and they will be penalized :)
|
|
Charlie Bruno on
2/23/2010
learned something new....
|
|
|
nic one
|
|
|
Very explicit. Very helpful.
|
|
|
Good video
|
|
Todd Burrell on
5/19/2010
I've seen screen shots of using psftp on another site, but the video helps explain it a lot more. Now all I have to do if figure out to how specify variables/expression for the file names to send since they are dynamic (date dependent) rather than using the ans files in the demo.
|
|
|
hi this is working fine. but when i deployed this in sql server 2005 and try to run it from sql server job it hangs.
Please suggest what to do?
|
|
|
its very good and helpfull for the DBA
|
|
|
Great
|
|
|
Very useful.
|
|
|
Good, but I would rather the video showed how to include a file in the arguments rather than the actual commands with the username and password information.
|
|
|
good
|
|
|
an excellent video
|
|
|
good
|
|
|
Hi there I received this error
[Execute Process Task] Error: In Executing "C:\psftp.exe" "10.7.50.111 -P 22 -l domain\sql_service -pw Password -batch -b d:\folder\Backup\ftp_in.ans" at "D:\Backup\srouce\DEV\folder", The process exit code was "1" while the expected was "0".
Any idea what I'm doing wrong?
|
|
|
Is it possible to change the port no from 21 to 22 for SFTP in FTP task ? Will it work?
|
|
|
I have got the same error as Shirley got "[Execute Process Task] Error: In Executing "C:\psftp.exe" "10.7.50.111 -P 22 -l domain\sql_service -pw Password -batch -b d:\folder\Backup\ftp_in.ans" at "D:\Backup\srouce\DEV\folder", The process exit code was "1" while the expected was "0". Any idea what I'm doing wrong?"
Can you please tell me whats wrong in it?
|
|
James Moore on
11/22/2011
Excellent! Just what I was looking for to complete a project I'm working on. Thank you for sharing.
|
|
Mike Nicholas on
12/16/2011
Very practical example. Thank you!
|
|
Jason Yousef on
12/16/2011
Thanks
|
|
|
Wonderfully valuable information!
|
|
|
Crystal clear - great diction!
|
|
Steve Harris on
12/16/2011
Great and pratical.
|
|
|
Very good presentation. I've been using psftp in SSIS for a couple of years and it's a pretty easy and cost-effective way to do secure file transfers within SSIS.
|
|
|
Very useful workaround, and quite simple presentation. Effective.
|
|
|
Oh boy! Back to the dirty dark days of DOS FTP! And to think, I had almost forgotten how to do this...but seriously, thanks for letting us know that there IS a way (however rudimentary) to FTP via SSIS.
|
|
|
Very informative. Good video! Thanks!
|
|
Kris Robinett on
12/16/2011
very helpful info
|
|
chandrasekhar on
12/16/2011
useful video on Secure FTP File Transfer in SSIS
|
|
|
Thanks for the tips!
|
|
|
sir, can u explain me how to export and import in between servers..thanks by dinesh...
|
|
|
Overly simple as this assumes you normally use PSFTP manually. The work comes with the initial setup.
|
|
|
very nice
|
|
|
Thanks for the video.
|
|
|
General comment pertaining to all videos in that you should also have printable pdf file pertaining to the video.
|
|
|
Should also show using certificates.
|
|
|
g8 one..helped me a lot
|
|
|
cool alternative!
|
|
|
It's great that you made this video available
|
|
|
Great post! I was trying to have it done by WinSCP and wasted my time there , this one worked great with PSFTP.
|
|
|
Good example. But having issues with schedule a job
|