DTS package not working correctly when run from another package -
06-26-2006
, 05:25 PM
I created a package in DTS. I then set up another package which runs this
package and then and SQL Task upon the failure of the 1st package. I then
forced the original package to fail but the SQL Task did NOT run. I then
changed the workflow to execute upon the successful completion of the 1st
package and the SQL task executed. Somehow, this package thinks the original
package succeeded even though the status says Error Occurred(30). Any ideas ?
[] Package
[] SQL Task |