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

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 FTP domt conected to the server
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

nord
Posting Yak Master

126 Posts

Posted - 11/22/2013 :  09:34:48  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

3873 Posts

Posted - 11/22/2013 :  10:40:33  Show Profile  Reply with Quote
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 - 11/22/2013 :  10:55:03  Show Profile  Reply with Quote
Yes,I can connect ,this port 22 maybe make me problem?
Go to Top of Page

nord
Posting Yak Master

126 Posts

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

James K
Flowing Fount of Yak Knowledge

3873 Posts

Posted - 11/22/2013 :  13:05:48  Show Profile  Reply with Quote
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 - 11/22/2013 :  13:21:13  Show Profile  Reply with Quote
Thanks,what I found too....
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52326 Posts

Posted - 11/23/2013 :  09:56:27  Show Profile  Reply with Quote
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 - 11/27/2013 :  13:55:24  Show Profile  Reply with Quote
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

India
52326 Posts

Posted - 11/28/2013 :  06:22:03  Show Profile  Reply with Quote
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 - 11/28/2013 :  16:18:41  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.11 seconds. Powered By: Snitz Forums 2000