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.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.||| 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|||

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

|||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.
|||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.

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.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.||| 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|||

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

|||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.
|||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.sql

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.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.||| 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|||

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

|||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.
|||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.

Frustrating: Can't get to Provider Options in SQL 2005 Express?

Hi,
I'm trying to get to the provider options screen in SQL2K5 Management
Studio, however I am unable to find it anywhere. This is really
frustrating... Here is what I am trying to do:
1.. In SQL Mgmt Studio, connect to the SQL Server Database Engine and go
to Server Objects->Linked Server->Providers in the Object Explorer.
2.. Right-click on a provider and select Properties.
However, all I can see when I right-click is "Refresh" ... How can I access
the provider options? Is this a limitation of the Express database? Is there
a stored proc I can use?
Thanks,
MichaelWhat are you trying to achieve?
Look at the sp_addlinkedserver system procedure.
"Thou shall lear to type. Clicking is the work of the Devil."
-- undisclosed apostle
;)
ML
http://milambda.blogspot.com/|||Thanks, but I have already used sp_addlinkedserver.
I am trying to set the "allow inprocess" provider options... according to
research in the NG's and BOL (see "Linked Server Properties (Provider
Options Page)"), this is set from a dialog that I am unable to access. I
can't see it when adding a new linked server, editing an existing one, or
right-clicking on the provider in Management Studio.
Any ideas?
Thanks,
Mike
"ML" <ML@.discussions.microsoft.com> wrote in message
news:99625079-C5D6-430C-89AB-8AD8421A2731@.microsoft.com...
> What are you trying to achieve?
> Look at the sp_addlinkedserver system procedure.
> "Thou shall lear to type. Clicking is the work of the Devil."
> -- undisclosed apostle
> ;)
>
> ML
> --
> http://milambda.blogspot.com/sql

Frustrating: Can't get to Provider Options in SQL 2005 Express?

Hi,
I'm trying to get to the provider options screen in SQL2K5 Management
Studio, however I am unable to find it anywhere. This is really
frustrating... Here is what I am trying to do:
1.. In SQL Mgmt Studio, connect to the SQL Server Database Engine and go
to Server Objects->Linked Server->Providers in the Object Explorer.
2.. Right-click on a provider and select Properties.
However, all I can see when I right-click is "Refresh" ... How can I access
the provider options? Is this a limitation of the Express database? Is there
a stored proc I can use?
Thanks,
MichaelWhat are you trying to achieve?
Look at the sp_addlinkedserver system procedure.
"Thou shall lear to type. Clicking is the work of the Devil."
-- undisclosed apostle
;)
ML
--
http://milambda.blogspot.com/|||Thanks, but I have already used sp_addlinkedserver.
I am trying to set the "allow inprocess" provider options... according to
research in the NG's and BOL (see "Linked Server Properties (Provider
Options Page)"), this is set from a dialog that I am unable to access. I
can't see it when adding a new linked server, editing an existing one, or
right-clicking on the provider in Management Studio.
Any ideas?
Thanks,
Mike
"ML" <ML@.discussions.microsoft.com> wrote in message
news:99625079-C5D6-430C-89AB-8AD8421A2731@.microsoft.com...
> What are you trying to achieve?
> Look at the sp_addlinkedserver system procedure.
> "Thou shall lear to type. Clicking is the work of the Devil."
> -- undisclosed apostle
> ;)
>
> ML
> --
> http://milambda.blogspot.com/|||Try setting the rest of provider settings through the @.provstr parameter of
the sp_addlinkedserver.
Some examples are available in Books Online.
ML
--
http://milambda.blogspot.com/|||Thanks. After doing some more research, I now know that this is a limitation
of SQL Server Express.
I was however able to use the following system stored procedure to change
the provider options:
EXEC master.dbo.sp_MSset_oledb_prop N'ProviderName', N'AllowInProcess', 1
I hope this can help someone else.
Thanks,
Mike
"ML" <ML@.discussions.microsoft.com> wrote in message
news:1CF1915F-6D1B-443F-B674-7C51B3139B79@.microsoft.com...
> Try setting the rest of provider settings through the @.provstr parameter
> of
> the sp_addlinkedserver.
> Some examples are available in Books Online.
>
> ML
> --
> http://milambda.blogspot.com/|||This is very helpful and good to know. Do you have a blog? Where have you
found the solution?
ML
--
http://milambda.blogspot.com/|||Hi,
Cindy Winegarden answered in microsoft.public.sqlserver.programming, when I
asked for the same problem (25/05/2006)
--
Michel Lévy
Communauté Francophone des Professionnels FoxPro
Pour un développement durable...
http://www.atoutfox.org
--
"ML" <ML@.discussions.microsoft.com> a écrit dans le message de news:
0BAB0C0C-0151-462E-94B0-9686347E430D@.microsoft.com...
> This is very helpful and good to know. Do you have a blog? Where have you
> found the solution?
>
> ML
> --
> http://milambda.blogspot.com/