Ah, thanks!

Hmmmm, I only get

'sqlcmd' is not recognized as an internal or external command,

operable program or batch file.

I have the full 2005 installed, is sqlcmd a seperate install now?

Will try it out, thanks a million.

It has something to do with distributed transactions.  Not sure why it's hanging like this but I'm taking them out.

Playing the theremin.

I got a professional Moog theremin to help get music back into my life and am now totally obsessed with it. Not only is it the only musical...

Today I tried setting all the SQL tasks to Read Uncommitted but that didn't help either. I'm holding off on resorting to putting presidences between all the execute package calls...

Thank you henrik staun poulsen.

That was a big help!

Well now I tried giving all the smaller sub packages which are called  the most their own OLE DB connection managers.  It was hopeful, but only worked a couple times through. Now...

Well now I tried turning off logging in all the packages except the master one thinking it might be some sort of deadlock there. No effect.

------------ Update:Just tried setting...

[lost post] Had set master package to delay validation, did not fix problem.

(actually 4/24 ended up here in 4/21)Well as a long shot I thought maybe it had something to...

Ah interesting.

Thanks so much for the pointer!

I can't have just one config file after all.  It works if the number values stored there are the same for every package, but as...

Yes I'm with you that's exactly what I've been trying to do from the beginning

I want to have one and only one single config file for all 15 or so...

Yes I've been storing them in the config and it usually works.  I think I figure out what's happening with it.  When I add a totally new package and set...

Cool thanks.

Yes I meant the green paths, I have an additional step to do after the insertion part only of the insert/update fork.  Will use SQL task and see if...

Yeah I think your right about the connections, they do not save the passwords.  Something though is sometimes deleting them from the config too, maybe it's happening when I add...