FTP Task Failure

Hot Topic

T-SQL Formatter in SQL 2000
Can't get VWD-Express Login control to work with IIS, Win2K and SQL 2005 Express
backup database by maintenance plan
Excel Connection Manager - Moving between environments
Reports with MDX queries on hierarchies loose rows on rendring
Reporting services on sqlserver express - help
Question about service configuration on SQL Server 2005 IA 64....
cannot convert between unicode and non-unicode
Client-side programming patterns/idioms for SQL Mobile 2005?
SQL Server 2005 SP 1 Failed during Reporting Services installation

SQL Server

Replace text/data in one table with corresponding text/data from another
can sql server allow to read record ramdomly?
Report Builder only for sql 2005 server?
pagesize of report is much larger than expected when printed
DB Mirroring Monitor and querying the "other" db?
CLR trigger in another schema
Management Studio Express CTP update now available
HELP --- I can't access cubes from excel
converting RS2000 reports to 2005
The target service name could not be found.

FTP Task Failure

We are unable to get a file from a VMS FTP site.  The specific error message is:

[ftp task] Error: File represented by "/VEQFFP.TR.MTSS.RATE" does not exist.

normal command line ftp and other ftp tools all succeed.  Is anyone else experiencing this difficultly

Thx in advance.

Answer this question

FTP Task Failure

  • SHMD

    Tongue Tied  Have already used cmd files to accomplish this task.  Want to use the new SQL FTP 2005 dtsx task.  Since the Mainframe Server sets us into the root, I have not way to manuever to the directory to capture the file I need.   Thx

  • Chris Koerner

    Hello

    Had problems with the FTP task opening more than one connection (this was ) to the server. Workaround was to use cmd ftp taking input from file. That was best practice at the time.

  • Atriplex

    I got the same error but it turned out that after browsing to the file to be downloaded using remote path, when I ran the task a configuration file was setting the ftp connection to a different server and then I received an error that the file did not exist.

  • dknoodle

    I have the same problem which prevents pulling files off VMS. Even if I use an account that lands me in the correct directory upon connection, VMS won't accept the leading "/" that the SSIS FTP Task forces you to use. I'm thinking of using a Script Task to create my own FTP task (using the FtpWebRequest class from .NET 2.0), as the standard one simply isn't flexible enough.

  • Leonardo Blanco - MSFT

    Hi.

    We are having the same problem.

    Usually you don't need the "/" however SSIS is forcing you to put a "/" or it won't execute.

    Have you found a workaround yet

    Thank
  • FTP Task Failure
Answer this question