question

sksamguru avatar image
sksamguru asked

how to create execute package task

There will be one container type package, which will execute all packages one after another in the following order: 1. A 2. B 3. C 4. Store\_Proc\_package 5. Store\_Proc\_package2 If any package 1-3 returns error – execute the next package. If all packages 1-3 return error – do not execute packages 4(Store\_Proc\_package) and 5(Store\_Proc\_package2) If package 4(Store\_Proc\_package) - do not execute package 4(Store\_Proc\_package) Then, this package will send email with the result to Email_To variable that is soft-coded either in the configuration file or in the RSAM database/Controls table. But I don't know how to defined precedence constrainst such a way that If out of all packages 1 will run – then execute packages 4(Store\_Proc\_package) and pick the email address from database and send return value to the users
sql-server-2008ssist-sqldeveloper
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.