FTP task error occurring

This is strange... just started getting this today, while it's worked for weeks. But alas, that is programming.

The error I'm getting is

[Connection manager "FTP DQ Connection"] Error: An error occurred in the requested FTP operation. Detailed error description: 200 Type set to I. 200 Command okay. 550 /usfsr/DFE_INPUT/FATest_DQ.txt: No such file or folder. .

I'm uploading a file (FATest_DQ.txt) to the folder /usfsr/DFE_INPUT/. I eventually just uploaded the file manually using IE6 to make sure the connection properties were still the same.

Any ideas?They changed the folder name on me... heh. Problem solved.

FTI and multiple columns - another question, but opposite behaviour?

I have a table with 2 FTI columns, but my query results seems strange. If I
run this query:
AND CONTAINS( J.*, '"DEVELOPMENT" AND "MARKETING" AND "FIFE"' )
it returns no rows.
AND CONTAINS( J.*, '"DEVELOPMENT" AND "MARKETING"' )
this returns one row as both words are in the same FTI column.
AND CONTAINS( J.*, '"FIFE"' )
returns the same row, as FIFE exists in the other FTI column.
So, why doesn't the top query return the row in the results? Is this normal
behaviour? Is there anything I can do to make it work?
Thanks.
A contains query can't look across columns, a freetext query can. So if your
hits come from different columns a freetext query will return a hit, whereas
a contains won't.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Joe Bloggs" <Joe.Bloggs@.acme.com> wrote in message
news:%23C6lxLZcFHA.2520@.TK2MSFTNGP09.phx.gbl...
> I have a table with 2 FTI columns, but my query results seems strange. If
I
> run this query:
> AND CONTAINS( J.*, '"DEVELOPMENT" AND "MARKETING" AND "FIFE"' )
> it returns no rows.
> AND CONTAINS( J.*, '"DEVELOPMENT" AND "MARKETING"' )
> this returns one row as both words are in the same FTI column.
> AND CONTAINS( J.*, '"FIFE"' )
> returns the same row, as FIFE exists in the other FTI column.
> So, why doesn't the top query return the row in the results? Is this
normal
> behaviour? Is there anything I can do to make it work?
> Thanks.
>

Fresh RS Install - weird bug

Hi all,

My RS install is having a strange issue. I've installed RS on an IIS Server and pointed to a remote server database. The IIS server is secured using an internally issued SSL cert.

After some tweaking, I've been able to get RS to work (almost) properly. I'm able to deploy reports from Visual Studio and view them through the RS Web App. Of course, I have admin rights on this box.

My problem is this: The web app won't let me add a New Role Assignment for my users. The only Role Assignment is BUILTIN\Administrators. I need to add a "Browser Only" role for the users. When I click "New Role Assignment" from the project folder's security menu, it displays the New Role Assignment page. I type in the group name and click the Browser checkbox. Finally, I click the OK button, but nothing happens. Its like there isn't an event tied to the button. However, the Cancel and New Role buttons work just fine.

Why aren't my OK buttons working? This is the most bizzare issue, but it's completely halted my production. I've tried re-installing RS but am having the same issue. Please, any help will be much appreciated.

Even a quick workaround to edit folder security would be nice at this point.

Thanks!Couple things:

1. Is it possible that the web browser you are using has scripting disabled?
2. Do you see a warning icon at the bottom-left of the browser after you click OK?|||

Yes - we've seen this kind of behavior when you are using an Internet Browser that does not support scripting. In SQL Server 2005, Report Manager UI supports most operations in browsers other than Internet Explorer - but it is not perfect. Underneath the covers, we use different ways of implementing buttons so being able to click some but not others is a symptom of this problem.

If you have trouble doing this in report manager, you can use SQL Server Management Studio in SQL Server 2005 to do this as well.

Hope that helps,
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.

Fresh RS Install - weird bug

Hi all,

My RS install is having a strange issue. I've installed RS on an IIS Server and pointed to a remote server database. The IIS server is secured using an internally issued SSL cert.

After some tweaking, I've been able to get RS to work (almost) properly. I'm able to deploy reports from Visual Studio and view them through the RS Web App. Of course, I have admin rights on this box.

My problem is this: The web app won't let me add a New Role Assignment for my users. The only Role Assignment is BUILTIN\Administrators. I need to add a "Browser Only" role for the users. When I click "New Role Assignment" from the project folder's security menu, it displays the New Role Assignment page. I type in the group name and click the Browser checkbox. Finally, I click the OK button, but nothing happens. Its like there isn't an event tied to the button. However, the Cancel and New Role buttons work just fine.

Why aren't my OK buttons working? This is the most bizzare issue, but it's completely halted my production. I've tried re-installing RS but am having the same issue. Please, any help will be much appreciated.

Even a quick workaround to edit folder security would be nice at this point.

Thanks!Couple things:

1. Is it possible that the web browser you are using has scripting disabled?
2. Do you see a warning icon at the bottom-left of the browser after you click OK?|||

Yes - we've seen this kind of behavior when you are using an Internet Browser that does not support scripting. In SQL Server 2005, Report Manager UI supports most operations in browsers other than Internet Explorer - but it is not perfect. Underneath the covers, we use different ways of implementing buttons so being able to click some but not others is a symptom of this problem.

If you have trouble doing this in report manager, you can use SQL Server Management Studio in SQL Server 2005 to do this as well.

Hope that helps,
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.