Oh well. I guess I'll have to be happy with the Task names from the control flow level.

Thanks.

thanks. but it's not quite what I was looking for.

That gives me the Data Flow Task name.

What I would like is (if possible) the name of the DFT internal step...

to my knowledge the Guage tool in reporting services is for SSRS 2 or 3, and SSRS version 2 and 3 require SQL 2008.

also you may need to check your collation

http://msdn.microsoft.com/en-us/library/aa174903(SQL.80).aspx

Good script. I've been meaning to get around to setuping a T-SQL script for mirroring to speed up the process, so this will give me a good start...

guys,

thanks for posting - I think i've now found the cause of the problem which seemed related to how I set the variable.

Personally I don't think outsourcing works.

At times technical requirements / skills set may require outsourcing, but when it's not - outsourcing is just as costly as inhouse development, if not...

Another suggestion that might be useful...

If you plan on doing the Production to Dev copy on a regular basis, you could setup a link server from DEV, pointing to the...

sorry answer to what?

What was the question?

The RS service should be set to manual on both machines.

You could certainly try to set the database server to start the service using an alert on boot up.

At the...

what sort of quirks/irritations?

at the moment it will be predominately me doing all changes, but I still want to set up a proper change control, for any ETL packages.

Thanks

Sounds like it should be possible then, so I'll set up a test server and try it I think, just to make sure.

Ok thanks Adam,

No, the database should be pretty standard (to my knowlegde the application db could be run on 2000!).

The reason for my question is that we will configure a new server...

Hi Jason,

The last post dissappointingly answered a question I had. My other question though, is what process would you recommend for upgrading SQL 2005 servers that are taking part...

there are a few things you need to do to use a single address such as http://LiveRS.domain.net/Reports working.

1 - both the servers will need to have a fixed IP address.

2...