No. There is no reason whatsoever to install those tools on the production server.

Maybe SSMS. Suppose the network is down and you can only access the server physically. (I hope...

To be honest, Craig stole it from me when it was...

* if the excel needs to be formatted, I would create a report in SSRS and export to Excel

* bcp

* SSIS

* Import/Export wizard

Jack Corbett (6/25/2014)

---

There aren't major changes to the BI suite between 2008 R2 and 2012. The biggest changes are in SSIS with little in SSRS. I'm...

Evil Kraig F (6/25/2014)

---

Sean Lange (6/25/2014)

---

Lynn Pettis (6/25/2014)

---

Sean Lange (6/25/2014)

---

Ed Wagner (6/25/2014)

---

Koen Verbeeck (6/25/2014)

---

Ed Wagner (6/25/2014)

---

SQLRNNR (6/25/2014)

---

Koen Verbeeck (6/25/2014)

---

SQLRNNR (6/25/2014)

---

Koen Verbeeck (6/25/2014)

---

ChrisM@Work (6/25/2014)

---

djj (6/25/2014)

---

Just saw a post (on another site)...

Ed Wagner (6/25/2014)

---

SQLRNNR (6/25/2014)

---

Koen Verbeeck (6/25/2014)

---

SQLRNNR (6/25/2014)

---

Koen Verbeeck (6/25/2014)

---

ChrisM@Work (6/25/2014)

---

djj (6/25/2014)

---

Just saw a post (on another site) that the person had part of a query list but no quest was...

No,...

Yes, SSIS can replace stored procedures. And vice versa as well.

That's about all we can say without further details.

The SSIS error messages are logged in the SSIS catalog. The reports in the SSIS catalog fetch their data from the SSISDB database.

In previous versions, the error messages were logged...

Stefan Krzywicki (6/25/2014)

---

djj (6/25/2014)

---

Just saw a post (on another site) that the person had part of a query list but no quest was asked. Someone posted "What is your...

peacesells (6/25/2014)

---

Koen Verbeeck (6/25/2014)

---

peacesells (6/24/2014)

---

I know in previous versions, msdb database would log/capture all sql server agent job details. Now with 2012 and SSISDB, if a job fails in...

No...

SQLRNNR (6/25/2014)

---

Koen Verbeeck (6/25/2014)

---

ChrisM@Work (6/25/2014)

---

djj (6/25/2014)

---

Just saw a post (on another site) that the person had part of a query list but no quest was asked. Someone posted "What...

ChrisM@Work (6/25/2014)

---

djj (6/25/2014)

---

Just saw a post (on another site) that the person had part of a query list but no quest was asked. Someone posted "What is your question?"...

djj (6/25/2014)

---

Just saw a post (on another site) that the person had part of a query list but no quest was asked. Someone posted "What is your question?" and...