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.
Go to Top of Page

nord
Posting Yak Master

126 Posts

Posted - 2013-11-22 : 10:55:03
Yes,I can connect ,this port 22 maybe make me problem?
Go to Top of Page

nord
Posting Yak Master

126 Posts

Posted - 2013-11-22 : 12:10:11
sorry this is :SFTP,I can use FTP connection in SSIS?
Go to Top of Page

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.
Go to Top of Page

nord
Posting Yak Master

126 Posts

Posted - 2013-11-22 : 13:21:13
Thanks,what I found too....
Go to Top of Page

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
Go to Top of Page

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
Go to Top of Page

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
Go to Top of Page

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
Go to Top of Page
   

- Advertisement -