Just split the datastream into two datastreams by using the multicast component. That way you'll have two outputs. Connect each of them to the corresponding file.

Script examples for Service Broker:

http://blog.sqlauthority.com/2009/09/21/sql-server-intorduction-to-service-broker-and-sample-script/

You must be doing something wrong, because I can export to multiple TIFF pages just fine.

Which version of SSRS are you using?

Get a 64-bit OS and put in more RAM?

Easy one, thanks Gail!

darrenkelly (1/25/2012)

---

Hi,

Koen Verbeeck and Evil Kraig F, thank you both for taking the time to reply. You have put my mind at ease. OLE DB it shall be.

Much appreciated...

johnnyk (1/23/2012)

---

It's this box kind of character that one of our oracle linked servers contains in its table that we are pulling data from. I have no idea how would...

It would block however the SQL Server user that is used by the cube to browse the data...

In SQL Server 2012, SSIS is inside the database engine. So you just need to connect to the regular database instance. You can still connect to the SSIS service however,...

Did you install the client tools?

In SQL Server 2012, BIDS actually doesn't exist anymore. It is merged along with other products into SQL Server Data Tools (SSDT), formerly know as...

What does the 3rd step do?

yuvipoy (1/24/2012)

---

Hi,

I am not using two systems only one system is been used.i tried to install all the .net fram work related to 2005 though it is not working for...

It becomes quite easy to answer all those similar concurrency questions if you've read the MSDN page after the first question 😀

Evil Kraig F (1/24/2012)

---

Hm. 11 records that...

You can merge those dataflows together. A dataflow can have multiple streams.