August 3, 2012 at 1:28 pm
We have recently migrated from a Physical 2005 server to a 2008 R2 VM server. We started to notice something weird of late. We have a parent package that executes a child package depending on a condition check. We have been observing that some days it takes couple of minutes for the child to execute where as on some days it takes an hour or more before the same child package starts executing.
Anybody experienced this before and can provide an insight.
Environment:
SQL Server: 2008 R2 VM Server.
SSIS: 2008 version
Thanks very much in advance.
Kesav
August 6, 2012 at 7:03 am
What are the condition checks? Is the child package a execute / don't execute depending on the condition, or does the condition change some parameters of the child? Is there anything else happening on the server at the times in question?
August 6, 2012 at 9:34 am
The condition does not change any parameters of the child. It is plain Execute / don't execute depending on the condition.
Basically depending on the condition value one or other child package is executed. we dont see the above mentioned experience when the second child package is called for execution.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply