Before you get into a dander any further. I have a couple questions, has this actually happened to you and how did you solve it? On reflection was...

How many people doctors are...

Alvin Ramard (2/16/2010)

---

CirquedeSQLeil (2/16/2010)

---

I don't get the impression that he is backing down at all from his position. He says he agrees, but I don't get the impression that...

I hope he enjoys that analogy..

GT-897544 (2/16/2010)

---

Elliott W (2/16/2010)

---

This whole post makes me laugh..

Basic Troubleshooting 101:

1. Find out WHY you have the problem in the first place

It is clear that GT-897544 has very little real...

Because it isn't likely to be down for hours. Reading the errorlog takes moments. And most causes of suspect databases can be resolved fairly quickly. But how...

I think I do too, I'm writing that down..

That whole chain made me laugh.. I can't believe...

This whole post makes me laugh..

Basic Troubleshooting 101:

1. Find out WHY you have the problem in the first place

It is clear that GT-897544 has very little real world experience, and...

You are welcome.

CEWII

No, unless you execute a delete statement you end up with the data that was just selected in both places. You do need to keep in mind primary keys,...

If you actually want to insert the data from table A into table B you can do something like this (assuming that the structure of both tables is the same)

INSERT...

It is especially frustrating from posters with low posting numbers.

I have to say that this stuff is getting kind of disheartening, it makes it difficult to WANT to...

I agree.

CEWII

I completely understand, because of the title I never looked at the group it was in.. But I stand by my recommend and the link posted.. and your...

I'd say the title pretty clearly says SSIS regarless of what group it was posted to:

"Dynamic Connection TO DIFFERENT INSTANCES in SQL SERVER SSIS 2008"

CEWII