Custom Component - Application.LoadFromDtsServer Intermittent Hang
Hi guys, I have built (well acquired and heavily modified) a custom component that allows calling packages within a package (it does things better than the stock one) As part of this I am calling the LoadFromDtsServer method and intermittently this is hanging on one of the calls, it is calling it and never returning. On a large family of nested packages every so often (and more often the more packages get called) this is happening. I know it is this call as I have information events firing either side. Can anyone give me any ideas on how to progress troubleshooting this? I have tried switching for LoadFromSqlServer but can't get the path to find the package (although I'm sure this is me doing something wrong but instead of MSDB\<package path> I am doing \\<package path> but it isn't working There shouldn't be any race conditions as each ssis custom package should be isolated from each other (and there is no shared storage.. exept between validate and execute but they shouldn't ever happen at the same time) The only other thing I guess I can do is to async the call and kill it if it timesout but seems a little extreme. So far not sure if this happens out of BIDS or not but just wanting to see if anyone had any thoughts on causes or things to try. Thanks for any help!
June 16th, 2011 2:21pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics