Ahh!

Yep, that's fixed it. Many thanks to both of you. 🙂

The GUID is the package identifier. You can use the /G option with DTSRun to execute the package using the GUID. The syntax for DTSRun is:

DTSRun

[/?] |

[

...

We've just gone through a cluster migration project and used the approach you outline. One thing you may find is that if you change the startup parameters of SQL Server...

Hi Umar,

As this is quite an old thread I expect you've got your cluster issue sorted now (or given up ;-)), but I've recently been doing the same thing.

I didn't...

From MSDN:

Before you can start to use FILESTREAM, you must enable FILESTREAM on the instance of the SQL Server Database Engine. This topic describes how to enable FILESTREAM by using...

Presumably you still have a the Distribution database available on Production and a backup of that database?

If so, just RESTORE the database using WITH MOVE to locate the .mdf and...

Mike,

Your function is useful because it returns extra...

Chris Howarth (6/2/2009)

---

It continues to amaze me that people don't use Integration Services (to pull data into a central repository) and Reporting Services to assist with tasks of this nature...

Interesting....on my Reporting Services installation the default is 'Native' rather than 'SharePoint Integrated'. Well done for resolving the issue. 😉

That should be fine - the fact that the Report Server is running would seem to rule that out as being the cause.

Gosh, you waited for 9000 seconds?! That is a long time. :w00t:

Just a thought: what happens if you replace 'localhost' with 127.0.0.1? E.g. in the browser type 127.0.0.1/Reports.

If that works...

Do you get the error immediately or after a long time? If it is after a long time, check the 'Connection Timeout' for the Web Site ReportServer is using (will...

Have you configured and started the Report Server from the Reporting Services Configuration GUI?

SELECT * FROM sys.server_triggers.

Surely it would have taken less time to look this up in BOL than post to the forum...?

Playing in this space is one that constantly irrritates me. I think it translates as 'we are going to target this particular market sector'.

Others are leveraging which is most cases...