What you can do is create a global variable, populate it, and then use that to dynamically set the string for each process task that you want to execute.

Let's say...

I run a server side trace to get this information (it's the only way I've found to capture reads against tables).

Run the below script, changing the filename, path and filters...

Are you running sp3?

I recall a bug in SP3 that caused SQL to bomb out when trying to define columns in an export. Go to sp3a and you shouldn't...

You could use the filescriptingobject within vb in a dts.

never yet been able to configure that and get it to work right

The accounts does have rights on the object (proved by virtue that the report is accessible from the servers domain).

The error is an IIS error, rather than an RS one....

If I could get trusts going my life would be so much easier Steve, unfortunately that's not going to happen any time soon.

When I go to the reports site it...

Are you not logging the dts itself? That would provide more information into the errors that you are getting.

Using a NAS isn't the best idea to start with.

I'd go with

exec sp_change_users_login 'Update_One', 'username'

Resolved that problem by adding the IUSR_ account to the browser role, however I still cannot view the report from the other domain.

The biggest impact that you'll see will be on disk, make sure that you backup (if backing up to disk) to a different physical drive than the logfiles.

You'll want the Oracle client tools on the SQL server, and then make sure (depending on the version of Oracle) that you have the correct entries in the registry (see...

I can't see the image that you posted, however, have you looked in the logs for the logshipping to try and figure out why the copy or restore is not happening?

What you'll more than likely find is that there are no tranasctions running against the database for the majority of the time and those times that the logs are bigger...