If anyone interested in knowing how I resolved and implemented the question in this thread, here it is:

Table: tSQLServers

Lists SQL Server names and other related fields.

SPROC: usp_get_SQLServers

Queries tSQLServers for ServerName...

If anyone interested in knowing how I resolved and implemented the question in this thread, here it is:

Table: tSQLServers

Lists SQL Server names and other related fields.

SPROC: usp_get_SQLServers

Queries tSQLServers for ServerName...

Read following KB on Microsoft for possible resolution:

http://support.microsoft.com/kb/816780

I found a script that I manipulated to suite my needs, but not sure if it is what I was looking for and if it's valid so I'd appreicate if you...

I understood all ther parts of your post more or less, but I am not clear as to how I use the 'results of my outer package...' Say I have...

Following is my solution and logic, in case anyone interested:

CREATE Procedure dbo.usp_Recycle_E_Login_ID

/*

*********************************************

Name:  dbo.csp_UPD_Employee_Login_ID

Purpose: Update an existing Login Name in Table_User so that it can be recycled to set up a new user...

You are asking for a report design, which SQL statement can't do from what I understand. You can write a SQL statement and SUM on the number field and GROPE BY...

I was hoping for .10 seconds or even less. I have to check how much memory SQL Server is utilizing when I am back at work on Monday.  There is...

Tried your suggested query design and still no difference - takes .29 to .33 seconds to execute.

The server has 1 processor and 2047 OP Memory. Log and data files are...

Ok, it did improve, but still NOT within expected range, I think. It took .33 seconds to run and query cost now was 100% Clustered index seek. Oh, this is...

Well, yeah, but I am doing performance tuning on another DBA's DB so wasn't sure if I should take the liberty to change her DB design! But, perhaps I can...

No, because both the tables already have a primary key defined as Clustered Index, which are different than t_MemberAccount.SSIN field.

When I say UserIDs, I mean if there is an ActiveX Script within DTS or something like that, which is passing an explicit connection string with SQL authentication to query...

Yes, it's happening at following line, which waits for user input then executes. If it never got the user OK then it failes right there at that line!

Set Excel_Application = CreateObject("Excel.Application")

I...

Yes, the fact that when I run the DTS manually, I am able to run it so yes, Excel is installed and all accounts have proper permissions on the server/folder...