SQL Server Forums
Profile | Register | 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
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

nord
Posting Yak Master

122 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

3565 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

122 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

122 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

3565 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

122 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
52309 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

122 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
52309 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

122 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  
 New 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.09 seconds. Powered By: Snitz Forums 2000