Solved

FTP Connection

Posted on 2008-06-24
4
832 Views
Last Modified: 2013-11-29
Hi Guys, I am having a problem with SSIS, specifically utilizing the FTP function. I created a FTP Task Connection but cannot get it to connect.
I entered the current Server name, User name and Pswd, ckd Use Passive Mode, insured I had the correct port. I then triple ckd all entries. I clicked Test Connection and received the msg Connection cannot be established

Is there something else I need to do?  

Thanx
0
Comment
Question by:Trudye
  • 2
  • 2
4 Comments
 
LVL 4

Expert Comment

by:LiorRon
ID: 21857380
Did you try this using the FTP utility from the command prompt ?
1. Start --> Run --> Ftp
2. type Help to see the available commands
3. Test to see if you can establish a connection
0
 

Author Comment

by:Trudye
ID: 21857764
Thanks LiorRon for responding so quickly
I entered the site address in IE ftp://....
I received the msg the site was a private site, so the site is valid. However I was never asked for login information.
0
 
LVL 4

Accepted Solution

by:
LiorRon earned 500 total points
ID: 21858012
Try:

1. Start --> Run --> Ftp
2. Open <Your FTP Site>

You should be prompted with a username and password.
Enter the same username and password you provided for the SSIS FTP.

What results do you get ?
0
 

Author Comment

by:Trudye
ID: 21861165
Sorry for the trouble, I was given a bad password
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

SSL is a very common protocol used these days when browsing the web.  The purpose is to provide security to communication, but how does it do it?  There are several pieces at work that have to be setup before SSL will even work and it requires both …
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question