I have an initial step in the process which removes duplicates as the destination system counts them, which follows an unusual sense of what a duplicated is. Also all records...

Thanks Sergiy, this is what happens when I forget myself and allow the various directors demanding too many things to get too me. That being, I tested on too small...

Just finished adding the concept to my code Jason, works like magic.

Its just beautiful!! :w00t:

Rock on Jason, that is just what I was trying to come up with. I had not considered the case statement. :w00t:

Thanks!

Thanks for the replies. I will take a look at the cross tab reporting and see if I can get it working.

Thanks again.

I have partial success presently. The error message no longer appears, however, I still can not connect to anything but the master DB on the 2005 server.

There are no linked...

Well that is different. The procs did change the name of the server correctly, however, when I try to connect I still get the error in the DTS tools.

I...

I had this thought, which perhaps someone can answer for me. This App1 server and App1t server, which based on the sp_helpserver thinks it is App1... both machines are...

The sp_helpserver did show the wrong server name, and network name.

Having not used sp_dropserver, I looked it up in BOL, and it is talking of a remote server?...

I would second Jeff's suggestion of views with the getting of external data in excel. Here we use that scheme heavily, our report users demand the ability to sort,...

Thanks Gail, I believe I follow it well enough now.

Of course, I will not know if its enough when I encounter a problem. Ahh, the fun of computers, never...

Ok, so when executed a view gains a cached execution plan, which is reused, similar to a stored proc. So is there a particular advantage to using a stored...

Matt Miller (3/3/2008)

---

Jeff Moden (2/29/2008)

---

Folks, when you do an interview, remember... you're not trying to show off how smart YOU are, you're trying to figure out how smart the other...

So I must live in a strange fantasy land, where those who will develope the project tell management it will take 4 weeks or such to build this, and management...

I have had similar problems with DTS, in my case I missed the real problem for a while as it was "too obvious". In my case when the error...