To execute an SSIS package, you MUST be executing it on an SSIS Server of the appropriate edition of SQL Server to run the components included in the package.

So, your...

I would first try increasing the amount of memory available for linked server drivers.

They use a portion of memory reserved by SQL Server for non-SQL processes running within SQL Server....

A VIEW is just a stored query.

If you create a view and run the same query, the performance will be the same.

Yes, that is pretty much it.

If you can, use NT Authentication in your data sources if connecting to SQL Servers. Even if you allow anonymous access to your application...

Here is part of where being a DBA can be a bit of an art.

Indexes and fragmentation can be avoided in several ways. First - let's get the clustered...

You either want

[font="Courier New"]Update a

SET a.SponsorXID = a.XID

FROM [consultant].[Consultant] AS a

INNER JOIN [consultant].[Consultant] AS b...

A trigger would probably be a better solution to this than SSIS. With SSIS, you would have to schedule a process to check the table for new entries -...

Right, so following Jeff's plan, a solution for your PK on the table would be to add an additional field that holds the length of the data in your column...

That actually violates the ANSI standard - look at the collation options, but I am not sure if you can get that to actually work.

I tend to agree. As far as performance, until you scal up to a couple hundred processors, they will be close anyway.

The "CI" indicates case-insensitive. "A" and "a" are the same. If you want the same collation but case-sensitive, it is: SQL_Latin1_General_Cp1_CS_AS

I suggest you look carefully at the collation...

I have not tried to install SQL 2008 RC0 on an XP machine. There may be an actual issue. You should check the MSDN forums and report your...

Are you able to manually modify dcom settings or registry entries?

Not that I would advocate what you are doing - looks like a real nightmare to me, but you just need to use a case-sensitive collation for the column. ...

It looks like you don't have access to DCOM. Did you install this as an administrator? When you run the install, right-click on it and run as adminsitrator.