The following two statements work as they should...

=First(Fields!LegalCode.Value,"DataSet1")

=Last(Fields!LegalCode.Value,"DataSet1")

The first passes the first value in the dataset to the linked report

The second passes the last value in the dataset to the...

If I remove the formula from the parameter settings, the error disappears, but the underlying issue still remains. For some reason setting the paramater =(Fields!BusUnit.Value, "matrix1_BusUnit") does not work.

I ma receiving an error when adding the scoping information. The name of the first grouping is matrix1_BusUnit and I am using that in the scoping. Is there an issue...

Textbox properties --> Navigation --> Hyperlink action

In here I have selected Jump to Report and picked the appropriate report. I then click on parameters and enter the following

report_type ...

Hey,

Just for anyone that may come across this, I resolved the error by simply adding SET FMTONLY OFF to teh stored proc and now the metadata ia aalways returned.

I have tried this but to no avail unfortunately and it is acting as before.

I can add one parameter, the InsDown without issue, but when I overwrite the hardcoded 2nd...

Hi Willem,

The parameters shouldn't affect teh...

Thanks for the replies folks. I got it working by running the WinSCP app under the service account, which craetd the key required for it to work when called through...

This method is used to restore all of the DBs and is in a procedure I cannot edit. It is a reporting server where each DB is restored alongside the...

This restore does drop the old DB and restores the new one...unfortunately I can't alter the restore method.

jbuttery (10/20/2009)

---

Is it possible to change the recovery model on the database to simple? In other words, is it possible to re-run the imports and processing?

Also, you could put the...

Shark Energy (10/20/2009)

---

What are the packages using? Data Flow with ADO or OLEDB? Loading from what source?

If you are taking regular log backups then I wouldn't truncate the log...

Yup, I had said that the log gets truncated nightly...I will probably size the log to 20GB, get some more disk space and truncate nightly, although it still kind of...

Thanks for all the responses guys - v helpful.

Thank you sir - issue resolved! I passed them to local variables in a script task.