have you stored all packages in msdb database or on server as file?

I am sure you might have resolved issue by now but just in case Not resolved then you may refer link

http://www.sqlvillage.com/Articles/Distributed%20Transaction%20Issue%20for%20Linked%20Server%20in%20SQL%20Server%202008.asp

that can guide you resolve this issue...

How long it takes to load data into publisher? What is latency between Publisher and Distribuor? What is latency beween Distributor and Subscriber?

You can use SQLIO utility that can be downloaded from http://www.microsoft.com/downloads/details.aspx?familyid=9a8b005b-84e4-4f24-8d65-cb53442d9e19&displaylang=en

I believe you are referring to Quorom. So, You are right ONLY MSDTC needs to be configured.

I came across similar situation as one of developer had same issue, re-installing BIDS had resolved issue. It started on his machine after he installed BIDS 2005 when he already...

you can create regsvr file with little extra effort. you may do it programatically.

regsvr fiile is XML file with extension regsvr.

Easy way to compile regsvr file is to export...

1. Since you are migrating from SQL Server 2000 so there is high chance that you may have code that is incompatible with SQL Server 2008. For example:

=*, *=, usage...

You can certainly run osql -L > c:\serverlist.txt to export server name

Duplicate post of same question you asked.

In that case,

1. Install sql server on node1 for instance running on node 1

2. Install sql server on node 2 for instances running on node 2

3. Install sql server...

Which edition on R2 you are getting this error in?

You can do it one report

Create three dataset and map that with respective Tables on Report Page or map that with sub report

It sounds that you have only one instance of SQL Server running on these 4 node cluster. If that is the case then you need to run your installation first...

Mani

This is not requirement if you are NOT installing SQL Server 2008 on Windows Server 2008 R2 but it is requirement to perform installation either using SlipStream method or Update...