Answered by:
Many Constraints in Precedence Constraint Editor

Question
-
Hi. I don't understand the work of (AND and OR) in Many Constraints Section.
How work the operator and - or, because in this image I don´t understand...
Tuesday, November 11, 2014 4:38 PM
Answers
-
It will start with script task 1 (ie Obtener Nombre...)
If task is success, it will execute Obtener Archivo and if failure Envair Correo Notification de Error
If Obtener Archivo is success it will then execute Validar and if not Mensaje de Error al Cargar el archivo which on success will execute Envair Correo Notification de Error
On succesful execution of Validar and if it satisfies expression set it will execute Limplar registros
On the completion of Validar regardless of result (success/failure) so far as expression set is satisfied it will execute Eliminar Log Errors, Grabar Log Cabecera, Mensaje de Error en registros and Envair Correo Notification de Error
On succesful completion of Limplar registros it will execute Cargar a la BD, Grabar Log Cabecera, Mensaje de Error en registros and Envair Correo Notification de Error
On completion of Cargar a la BD if expression set is satisfies it will also execute Eliminar e Archivo de LogErrors si todos...
Every time Grabar Log Cabecera gets completed succesfully it will execute the four sequential file system tasks (ie Hacer Backup and following tasks in the path)
Please Mark This As Answer if it solved your issue
Please Mark This As Helpful if it helps to solve your issue
Visakh
----------------------------
My MSDN Page
My Personal Blog
My Facebook Page- Proposed as answer by Katherine Xiong Thursday, November 13, 2014 10:59 AM
- Marked as answer by Katherine Xiong Wednesday, November 19, 2014 12:57 PM
Tuesday, November 11, 2014 5:00 PM -
this article explain that:
http://blog.sqlauthority.com/2014/03/26/sql-server-ssis-execution-control-using-precedence-constraints-notes-from-the-field-021/
- Marked as answer by Katherine Xiong Friday, November 21, 2014 5:53 AM
Friday, November 21, 2014 5:06 AM
All replies
-
It will start with script task 1 (ie Obtener Nombre...)
If task is success, it will execute Obtener Archivo and if failure Envair Correo Notification de Error
If Obtener Archivo is success it will then execute Validar and if not Mensaje de Error al Cargar el archivo which on success will execute Envair Correo Notification de Error
On succesful execution of Validar and if it satisfies expression set it will execute Limplar registros
On the completion of Validar regardless of result (success/failure) so far as expression set is satisfied it will execute Eliminar Log Errors, Grabar Log Cabecera, Mensaje de Error en registros and Envair Correo Notification de Error
On succesful completion of Limplar registros it will execute Cargar a la BD, Grabar Log Cabecera, Mensaje de Error en registros and Envair Correo Notification de Error
On completion of Cargar a la BD if expression set is satisfies it will also execute Eliminar e Archivo de LogErrors si todos...
Every time Grabar Log Cabecera gets completed succesfully it will execute the four sequential file system tasks (ie Hacer Backup and following tasks in the path)
Please Mark This As Answer if it solved your issue
Please Mark This As Helpful if it helps to solve your issue
Visakh
----------------------------
My MSDN Page
My Personal Blog
My Facebook Page- Proposed as answer by Katherine Xiong Thursday, November 13, 2014 10:59 AM
- Marked as answer by Katherine Xiong Wednesday, November 19, 2014 12:57 PM
Tuesday, November 11, 2014 5:00 PM -
this article explain that:
http://blog.sqlauthority.com/2014/03/26/sql-server-ssis-execution-control-using-precedence-constraints-notes-from-the-field-021/
- Marked as answer by Katherine Xiong Friday, November 21, 2014 5:53 AM
Friday, November 21, 2014 5:06 AM