Originally posted by: SystemAdmin

I am using sftp for my maps.I have given the following command
-URL FTPS://<userid>:<password>@IP:22/<folder>/<filename> -t
at then outputcard.But I am getting the error.
I tried using put as
=put("ftp","-URL FTPS://<userid>:<password>@IP:22/<folder>/<filename> -t","data")
even then i am getting the same error.Can anybody help me how to resolve this.
I have attached the trace file also.
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: repanzer

I'm assuming you changed the trace file or code before you posted this, right?

I mean, the IP address you're trying to connect to is not "IP", right?
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: repanzer

Without the security patch, I used FTP scripts to do SFTP, and for every new connection, I had to talk to my network team to punch a hole through the firewall to connect to them.
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

You are right rep, i changed all the attribute values in trace file before posting due to the security restrictions at my work place.I am still not clear about how to resolve this.Please help me.
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange

Originally posted by: repanzer

I had to ask.

"Connect refused" isn't "couldn't connect" or "failed to connect"; it sounds like it has the ability to hit the IP, or try to, it's just not allowed to.

I don't have the security package, so I don't have the adapter and have never used it, I've used command line SFTP. Have you tried that? From the ppty prompt (or what ever it is), manually?? Can you ping the IP? From what I recall, I had to do it manually the first time, because every new connection asks the user a response, looking for a y/n answer. You're best bet is to do it manually to confirm it's even possible, then when you know it is, debug the adapter commands, which more then likely will not be nessecary once you can connect manually.
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: thorstenhirsch

Are you sure that the ftp adapter can handle sftp? I thought it's ftps (ftp+ssl) only.
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange

Originally posted by: repanzer

No, the FTP adapter can not handle SFTP, and now that you say that, I guess I assumed the person knew whether they had the SFTP adapter pack, but the trace file does say "FTP Adapter, Version 8.2(77)", not SFTP adapter.
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender