You need to remove the variables from the ReadWrite variables list and use the Variable Dispenser to unlock the variable for write within the script component.

Check out this link.

Can they use the query window to execute T-SQL statements against the database?

I love baseball on radio, except on...

What are you doing with the string inside the stored procedure? You probably should look into a Split Function that puts the values into a table. Check out...

I don't know of anyway to do this in SSRS if you are talking about enabling and disabling parameters. The only way to do this is to have another...

To my knowledge there is no way to do all the DBA tasks without granting the someone the ability to manipulate the data. You can audit everything as Eric...

Check out this blog post. I think it explains why you are seeing this behavior.

I like both American football and soccer. I did not like soccer until I had the opportunity to coach it at the Junior High/Middle School level and really learned...

Can you post some examples? Are you using select list parameters or textboxes? By default SSRS passes the value in each parameter. You can use IIF to...

Is SQL Mail started? Do you have a MAPI Profile setup for the SQL Server service account?

I agree with Bruce. With additional idea that:

select product.name, person.name from product inner join person on ...

Will send the columns name and name to the calling application so how...

I use SSRS and now with the RepotViewer control in .NET it's even better.

I'm not sure that i really understand your question, but if your question is:

"How do I remove the row with a NULL value for wce_ilr.EDRS?", here is how I'd do...

I would recommend SSIS as it has all the tools you need to develop the transfer(s) quickly. You are right to be somewhat concerned with performance as SSIS will...

What version of the client tools are you using, including service pack? What version is the report server including service pack?