Evil Kraig F (6/21/2012)

---

Um, that's Charmer, nothing new there. He's always had a very difficult time with the English language,...

AlexKlein (6/21/2012)

---

Hi Lynn,

Again - hear you loud and clear! Of course, I can't say much about the issue you had in the past without knowing the exact details, however I...

AlexKlein (6/21/2012)

---

Hi Lynn,

Again - hear you loud and clear! Of course, I can't say much about the issue you had in the past without knowing the exact details, however I...

I have used Diskeeper at a previous employer. We used it to keep fragmentation down, but to defrag the database files, we actually needed to shutdown SQL Server. ...

Charmer (6/21/2012)

---

Lynn Pettis (6/21/2012)

---

So, one of the problems you are having is that you don't see some third party components you have install in your...

mohan.bndr (6/21/2012)

---

Hi,

One of the job integration job was failed today. It was scheduled every day. And I found the error '0' after investigation.

could you please tell why it has failed...

yb751 (6/21/2012)

---

GilaMonster (6/21/2012)

---

This actually sounds like a case for partitioning. Partition the main table, make sure the staging table is identical (indexes, constraints, columns, etc) then to move the data...

So, one of the problems you are having is that you don't see some third party components you have install in your toolbox, correct?

You can run the BIDS application and build SSIS...

Since you are using Enterprise Editon, I'd go with Gail's suggestion.

Sounds like you can fire up BIDS for SQL Server 2005, correct?

Brandie Tarvin (6/21/2012)

---

Or English is not his first language and he doesn't yet...

You do know that you don't need Interation Services service running in order to develop, deploy, and run SSIS packages, right? You only need it to manage the packages...

Been a while since I had to deal with distributed transactions over linked servers. I found the problem to be in the configuration of MSDTC. I wish I...

GilaMonster (6/21/2012)

---

This actually sounds like a case for partitioning. Partition the main table, make sure the staging table is identical (indexes, constraints, columns, etc) then to move the data from...