February 3, 2009 at 1:53 pm
Hi am relatively new to SQL administration. I have some ftp DTS packages that connect to remote site and download some file. there have recently been some change in our file wall setting and as such in order to connect to the ftp server it requires passive ftp.
i am looking for a way to config the FTP DTS to connect using passive. I have had no such luck.hope you can assist.
I would appreciate and work around or activex script that does this that can run on the SQl server.
February 4, 2009 at 10:31 am
I am not sure exactly what you're doing, but when in passive mode it is a lot easier to connect FTP.
Active mode means that the server that you are connecting to checks every message that comes to it.
If it worked active it should work Passive.
Dam again!
February 4, 2009 at 2:44 pm
Hi Thanks for the reply.however the issue i am having is that when i excute the DTS it connects to the server but i cannot see the file. when i run http://ftp.exe to determine the casue the message that display is unable to build data connection. From the same machine i can connect using IE ;based on checks IE is running passive ftp. this is only difference i see on the machine.
Is there a way to configure the DTS task object to use use passive ftp. in the setting i don't see an option for determining the connection type
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply