No SFTP Task Component in SSIS 2005/2008? No Problem!

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Stan Kulp » No SFTP Task Component in SSIS 2005/2008? No...

47 posts, Page 5 of 5

«««1 2 3 4 5

No SFTP Task Component in SSIS 2005/2008? No Problem!

Rate Topic

Display Mode

Topic Options

Author

Message

suslikovich

Posted Tuesday, August 16, 2011 10:23 AM

Grasshopper

Group: General Forum Members
Last Login: Today @ 1:35 PM
Points: 12, Visits: 222

Peter, thank you. I actually don't need to change a directory. I might want to do it in the future but for now a directory where psftp.ext is sitting is fine.
I ran the same command I generat inside the code but manually by opening the psftp and I was able to copy the file.
Since I was able to copy a file from my machine to the server, I don't think the problem is with the credentials/accounts used (me vs. SSIS). I am stumled upon this really.....

Post #1160656

suslikovich

Posted Tuesday, August 16, 2011 10:45 AM

Grasshopper

Group: General Forum Members
Last Login: Today @ 1:35 PM
Points: 12, Visits: 222

This is very weird but when I added lcd and created a subfolder within the folder that contains the psftp.exe, I was able to copy the file! I tried wildcard to copy all .xml files and that did not work.... Hmmm, at least copying one file works.
Thank you, Peter!

Post #1160671

Peter De Ceulaer

Posted Tuesday, August 16, 2011 11:31 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, May 17, 2012 1:25 PM
Points: 9, Visits: 64

for the wildcard you need to use mget instead of get (as per putty docs)

Post #1160693

suslikovich

Posted Tuesday, August 16, 2011 12:23 PM

Grasshopper

Group: General Forum Members
Last Login: Today @ 1:35 PM
Points: 12, Visits: 222

Yes, I just figured that out. Thank you!

Post #1160739

cafescott

Posted Thursday, May 17, 2012 1:11 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 2:17 PM
Points: 109, Visits: 498

Hello,

I have read the article and the discussion with interest. I've tried to build and run a package that moves a file on our company's network to a test SFTP location.

I've attached an email task to the OnError event. I'm not getting any errors via email or when I see the window when I am running the package.

Unfortunately, the package hasn't yet worked. I'm wondering if that is because putty needs to have a private key specified. (When I connect via WinSCP to see if the file is where I am trying to put it, I need to specify the private key.)

If the private key is the problem, how would I implement that in the original solution?

thanks,

Post #1302094

Peter De Ceulaer

Posted Thursday, May 17, 2012 1:27 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, May 17, 2012 1:25 PM
Points: 9, Visits: 64

I've dropped the putty solution in favor of ssissftp.codeplex.com, a custom package that has worked very well for me.

Post #1302106

angel_mata

Posted Wednesday, December 05, 2012 8:42 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 8:44 AM
Points: 3, Visits: 188

Hi Mark,
Great post on the C# script. I'm a complete newbie with this. Do you have a download version of the script?

Post #1393057

« Prev Topic | Next Topic »

47 posts, Page 5 of 5

«««1 2 3 4 5

Permissions