Great, I'm glad you figured it out! 🙂

My hunch is that there's still something missing here. You said you only ran these packages from BIDS, but try dtexec.exe from the command prompt. Do you still...

I'm willing that if you try to run these without BIDS, you're going to see the error. I'm not 100% certain on this, but when a child package is...

when you say you can run each package separetely and have them complete successfully, are you running them from a command prompt or are you running them from a job...

You should probably try running SQL Profiler and capture what's being passed in by the SSIS package.  That'll give you a good idea of what the system is doing.

Instead of an array of strings, or temp tables, pass in XML variables instead.

I agree with what you're saying.  XML is a great way to pass arrays of variables into procedures, especially if the arrays need to be multidimensional in nature...  parsing apart...

The way I do it from a stored procedure is calling xp_cmdshell, then using the "dtexec" command to call the package.  It works pretty well, but I'm guessing there might...

something else to consider...  with anything launched in sql server 2000, you have a limited shelf life of support left.

http://support.microsoft.com/lifecycle/?p1=2852

April of 2008 is it for mainstream support.  With 2005,...

I can't think of any real productivity gains.  I happen to like Management Studio better than query analyzer, but the basic technology's still the same.  I'd argue that you're more...

I run the risk of being wrong here since I don't know the internals of your package, but it sounds like you've set up a package to run all of...

Yeah, I like the fact that this product sits pretty seemlessly on top of Management Studio.  It makes me wonder if microsoft is ever going to get their own version...

As a good friend once said "if it isn't painful, it's not worth it." 

if they're on the same server, that's easy.  You just need to use the following naming convention:

select * from

database1.dbo.table1

select * from

database2.dbo.table1

You can even join the values together...

select *

from...

Database mirroring should be enabled & supported by SP1.  The article's old.