November 30, 2006 at 5:27 am
Hi All,
We've got a problem where a top level DTS package fails in our DEV & QA environment as expected but completes successfully on our live environment for the same scenario.
All packages use fail on first error and have a call tree structure where other packages are called. I have carried out tests to prove that the error is being passed up to the top level package in our QA environment. Packages are stored as structured files and are called from these files using SQL Agent jobs.
The live environment consists of two clustered W2K3 servers and the DEV environment is a single node W2K3 server.
Any help would be most welcome
Live: SQL Server 8.00.760 (SP3)
QA: SQL Server 8.00.760 (SP3)
Thanks,
Danish.
November 30, 2006 at 10:46 am
Just so I'm clear about this: your top level package is a parent that executes child packages with Execute Package tasks and you expect the parent package to fail if a child package fails?
If that's your situation, perhaps the child packages in the live environment don't use inherited transactions. Check the workflow properties of the Execute Package task and see if "join transaction if present" is checked. If it's not, the child package could fail without failing the parent package.
Greg
Greg
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply