FTP domt conected to the server

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SSIS and Import/Export (2008)

FTP domt conected to the server

Author

Topic

nord
Posting Yak Master

126 Posts

Posted - 2013-11-22 : 09:34:48

Hi,
Iwould like create ssis simple download files from FTP to the our server,I did same like in the link:
http://www.mssqltips.com/sqlservertip/2884/sql-server-integration-services-ssis-ftp-task-for-data-exchange/
but FTP doesnt connected i give me errror:
[Connection manager "FTP Connection Manager"] Error: An error occurred in the requested FTP operation. Detailed error description: The operation timed out
How I can resolve this error
Thanks

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-11-22 : 10:40:33

Are you able to connect to the ftp server from windows explorer or using another program such as Filezilla? I have seen this error message usually when the ftp server cannot be reached - for example, if a firewall is blocking access.

nord
Posting Yak Master

126 Posts

Posted - 2013-11-22 : 10:55:03

Yes,I can connect ,this port 22 maybe make me problem?

nord
Posting Yak Master

126 Posts

Posted - 2013-11-22 : 12:10:11

sorry this is :SFTP,I can use FTP connection in SSIS?

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-11-22 : 13:05:48

From what I can tell, SFTP is not available by default - see here: http://www.bidn.com/blogs/KeithHyer/bidn-blog/633/winscp-from-ssis-secure-ftp-transfers
But, I must confess that that statement is just based on my googling skills.

nord
Posting Yak Master

126 Posts

Posted - 2013-11-22 : 13:21:13

Thanks,what I found too....

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-11-23 : 09:56:27

quote:
Originally posted by nord

sorry this is :SFTP,I can use FTP connection in SSIS?

you can by using a free SFTP client like WinSCP
see
http://visakhm.blogspot.in/2012/12/implementing-dynamic-secure-ftp-process.html

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

nord
Posting Yak Master

126 Posts

Posted - 2013-11-27 : 13:55:24

Hi,
I connected to ftp server using Core FTP and I would like run this using ssis,using execite process task,but how I can transfer all info to the Core FTPcorecmd.exe assword,username)?
Thanks

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-11-28 : 06:22:03

quote:
Originally posted by nord

Hi,
I connected to ftp server using Core FTP and I would like run this using ssis,using execite process task,but how I can transfer all info to the Core FTPcorecmd.exe assword,username)?
Thanks

did you try passing them through arguments property in Execute Procee Task

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

nord
Posting Yak Master

126 Posts

Posted - 2013-11-28 : 16:18:41

Yes,
I have 2 program:Core FTP,WinSCP
I tried to connect manually its work perfectly,but I need connect to server SFTP,port 22 use ssis,but with 2 this program i have same ussue,dont found host with WinSCP and with Core FTP connect to another server with port 21
I have txt file,maybe problem with my file:
option batch on
option confirm off
open sftp://<<Username>>:<<Password>>@<<SFTP Server>>:<<22>>
cd ITR_Test
cd ToITR
get *.* <<C:NewFTP>>
close
exit
PLease help me with this ussue,seaching in google,but no answer
Thanks a lot

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources