you'll need to create a linked server on one of the databases (where you want the query running) to the other one

So if the linked server was created on CONTRACT...

Well if someone else is paying...

The third way is to build the RDL documents in your own application and publish those to the report server.

The RDL documents are in...

Ouch! Rather you than me

Are you sure that report builder is the best solution?... if you want users to be able to "customise"...

are these going to be internal or external users?

Try and get hold of this book... for £30 its possibly one of the best value books you can buy

SQL Server 2005 Reporting Services in Action

It is 2005 specific...

bubu (5/12/2009)

---

Thanks for the reply, I thought about that myself but then I was thinking about the rights the user will have on the server? How will he connect to...

Shiv (5/7/2009)

---

I would suggest defining a linked server in SQL Server 2008 pointing to Sybase 10 server, using ODBC or OLEDB for Sybase. You should be able to access tables/objects...

It can't be done... Report Builder is not a web application - it is a locally ran application that temporarily installs/executes on the users PC over the network

What you can...

As far as...

From personal experience (10 years) I'd say that the .NET stipulation is misleading, you're...

Roy Ernest (5/11/2009)

---

Another option is to install SQL 2008 and use its Compressed Back ups. It compresses pretty good. I was able to compress a 300 Gig DB to a...

You can change the number of records to buffer and maximum commit size in the ole db destination dataflow component.

Other thing to try is to drop all indexes and foreign...

ouch... sorting large data sets in SSIS for a merge join is a nightmare

Even if the data was sorted in the text file SSIS will still want to sort it...

Grant Fritchey (5/11/2009)

---

It was extremely frustrating looking through stacks of resumes, most with 3-7 years of experience but with only 1 in 10 able to answer a majority of...

Dean Jones (5/8/2009)

---

ok fair enough, data warehouse. what exactly is a data warehouse and even if we were to do this, we need to get data from live to the...