Some additional information: If I run a test connection on my connection manager it works. When I run the package it fails. I've tried with both Windows...

I tried changing "Initial Catalog" to "Database" with no luck. One other thing that I have noticed is that the errors I'm getting are named pipe connection errors. ...

Data Source=ServerB;Initial Catalog=DBA;Provider=SQLNCLI.1;Integrated Security=SSPI;Auto Translate=False;

There is a package configuration that uses a parent package variable to modify the ServerName attribute.

When he tried to register it manually he got no error, but no success message either.

The developer with the problem made the change you suggested but still no luck. He did mention that he had tried uninstalling and reinstalling the DTS Designer and that...

Great question. I love the ones that show me something new.

Sorry, I should have posted this initially.

TITLE: Object Explorer

------------------------------

This package cannot be edited.

SQL Server 2000 DTS Designer components are required to edit DTS packages. Install the special...

cdonlan 18448 (8/23/2011)

---

jfmartin (8/18/2011)

---

I understand but... is it only in IT that we have a lot of changes ?

I think its the same thing everywhere, in construction, transportation, etc.

For me,...

Kenneth Wymore (8/22/2011)

---

Kenneth Fisher-475792 (8/22/2011)

---

David Walker-278941 (8/19/2011)

---

You're welcome. Thanks...

David Walker-278941 (8/19/2011)

---

You're welcome. Thanks for the kind reply....

Great story, I think I worked for them one time.

Of course I was young and stupid, and when the contract (for a software conversion project) had one short...

Great question. NUMA is something I had never heard of before this series of questions and I'm certainly learning a lot.

Great question. I loved reading the blog and the discussion to date. I think I'm going to have to get myself a SQL Internals book one of these...

Tom.Thomson (8/2/2011)

---

Kenneth Fisher-475792 (8/2/2011)

---

I do apologize that you felt that "Odd # of CPUs other than 1" and "RTM Install, when no service pack or hotfix was mentioned" were "unbelievable...

shannonjk (8/2/2011)

---

The question was fine, as I see 'installation of SQL Server 2005 Enterprise edition" as being installed with no service packs. The answer however is inaccurate (though I answered...