No amount of job security is worth that headache.

One more clarification.

When you navigate to the .dtsx file, are you logged into the "Production 64 bit Win2k3 server" (either via rdp, or sitting at the server)?

This production server is...

Assuming you have not used any features that are not supported in the standard edition, you can detach a database from SQL 2000 Enterprise and attach it to SQL 2005...

I think having a quantity of "411 Elm Street" indicates some overstock.

I would put them on sale.

Also, don't be afraid to post the "How do I?" on this site when you need expression help. There are some people that watch these forums that are really...

BTW - I would go with variables and expressions before using the ForEach loop container. It will be a much cleaner solution.

Previous month:

[font="Courier New"](MONTH((DATEADD("MONTH",-1,GETDATE()))) == 1 ? "January" : MONTH((DATEADD("MONTH",-1,GETDATE()))) == 2 ? "February" : MONTH((DATEADD("MONTH",-1,GETDATE()))) == 3 ? "March" :

MONTH((DATEADD("MONTH",-1,GETDATE()))) == 4 ? "April" : MONTH((DATEADD("MONTH",-1,GETDATE()))) ==...

I assume there will be some sort of rules engine that will determine how many "Name" attributes a particular type of object can have and how to relate the "Name"...

It is a little tricky because the database connections get checked during package validation unless you set DelayValidation to true.

In the cases in which I have had to do this,...

Unless, like me, you get stuck with half of the applications you are dealing with being on an old version of Oracle.

Then you have to constantly switch between the two...

[font="Courier New"]SELECT

CP.ClientID

FROM

#ClientProduct CP

LEFT JOIN #ProductFilter MHO ON MHO.ProductID = CP.ProductID AND MHO.HasOrdered = 1

LEFT JOIN #ProductFilter MNHO ON MNHO.ProductID = CP.ProductID AND MNHO.HasOrdered = 0

LEFT JOIN #ProductFilter IA ON IA.ProductID...

As a CTE, even if there were the same CTE, they would get translated into individual sub-queries. So, combining them just makes the logic complicated as does not help...

Ok, there is probably a more efficient way than this, but keeping it simple and just creating sub-queries (using CTE syntax to make them look nice) for your criteria, this...

So the product filter table applies to every client?

RetainConnection will not help you. Each child package has it's own connection manager. The fact that they have the same name does not mean anything.

So, you need to...