November 9, 2010 at 8:20 am
I have a SSIS package that doesn't seem to be behaving as it should.
The package has three steps and connects to two servers.
Step1: Execute TSQL using connection to Server B. On Success --> Step 3. On Failure --> Step 2.
Step 2: Notify operator task using connection to Server B. On Success --> Step 3. On Failure --> nothing (package fails and stops)
Step 3: Execute TSQL using connection to Server A. On Success --> end. On Failure --> end.
The package runs on Server A. When it runs, it executes Step 1. If Step 1 succeeds, the package stops. If it fails (I forced a fail by putting a syntax error in the tsql), it executes Step 2, then the package stops.
I have the package write to a log and all the log shows is step 1 (or step 1 and 2) running.
I don't know why Step 3 never runs. Any ideas?
November 9, 2010 at 8:41 am
Nevermind.. I think I figured it out.. The constraints are ANDed, so Step 3 was never executing because the precedents from both Step 1 and Step 2 were never true at the same time. Deleting the precedence from Step 2 to Step 3 and changing the precedence from Step 1 to Step 3 from On Success to On Completion solved the problem.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply