FTP TASK PROBLEM

Dear all,

I have problem in my ftp task.For example,
I create two variable remotepath and localpath to set up remote and local path of ftp task. And the IsRemotePathVariable and IsLocalPathVariable is set to true.

I create two funtions to retrun the pathvalue. The return value

is like 'D:\A.TXT' , but in DTSX the varible value is changed to 'D:\\A.TXT'. So my ftp task fail.

How can I overcome this problem?

Thanks a lot.

Regards

wen

Replace all occurences of "\\" with "\" if its causing you a problem.

You can do this in an expression.

-Jamie

|||

It doesn't actually change the value. It is just that the undelying engine for SSIS is written in C and "\" is an escape character. To actually display the value of "\" it has to be preceeded by a "\". so to use/display it in a string it appears as "\\". For example \r actually means a carriage return.

As for your situation what error are you getting?

|||

when the path value is changed to "\\" , the error is as bellow,

Error: 0xC0029183 at FTP Task, FTP Task: File represented by "User::FTPPATH" does not exist.
Task failed: FTP Task

sql

Front End Access and Back End as SQL Server

Dear Friends,

We have MS Access database with Forms and Reports, which was started 10 years ago by users and now the data is growing very rapidly.

Did anyone tried by having MS Access as front end and SQL Server 2000/2005 as backend with minimum modifications to the forms and reports in MS Access?

Please let me know, your ideas and if there are any links in the web or in Microsoft please provide here.

Thanks in advance,

Wrong forum for this - you might try the Database Engine forum (http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=93&SiteID=1)

or the Getting Started forum (http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=158&SiteID=1)

From ADO.NET 1.1 to SQL 2005 and SQL 2008

Dear Sirs.

I have Client Server Application
on Client Side i have .NET 1.1 WinForm Application
on Server Side i have SQL Server 2000

I'm using "OLE DB PROVIDER FOR SQL SERVER" for the Data Access

1)

I'd like to upgrade Server Side to SQL Server 2005 (I will copy same database with users to sql2005)

Should i update Clients to .NET 2.0 too ?
Do i need install Native Client Lib on Client ?

2)

when SQL Server 2008 is Relesed
Can i connect to it from .NET 1.1 Application ?

Thank you in Advance.

Should i update Clients to .NET 2.0 too ?

You don′t need to, for better reliability and without any further test and turning on the whole testing machine, I would use the 1.1 Fw.

Do i need install Native Client Lib on Client ?

You don′t need to but can do this.

2)

when SQL Server 2008 is Relesed
Can i connect to it from .NET 1.1 Application ?

Yes, thats the plan (Even if you use OLEDB providers) :-)

Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

I'm using SQL Data Provider in Name space System.Data.SqlClient

|||dito.|||What do you mean ? in word "dito" ?|||The same applies for SQLClient