locked
Many Constraints in Precedence Constraint Editor RRS feed

  • 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...

    img

    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 CabeceraMensaje 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/

    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 CabeceraMensaje 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/

    Friday, November 21, 2014 5:06 AM