Post reply

Execute SQL Task not firing

  • December 9, 2013 at 9:51 am

    #144829

    I've got an execute SQL Task that isn't firing at all in my SSIS package (2008). The System File Task runs fine but the Execute SQL Task doesn't even kick off. Precedence Constraint is based on Success for both. I've even tried "On Completion" for the precedence and it still doesn't work. The whole package completes successfully too.

    Probably an easy fix but not sure what I'm missing.... Any clues?

    Data Flow Task (Flat File-> Bulk Insert ADO.Net connection)

    |

    |------>System File Task (Runs fine)

    |

    |------>Execute SQL Task (Doesn't even run)

    **Update... okay I have two Successful paths to my execute SQL task. If I remove one of them it fires from the Data Flow task.

    Is it not possible to execute a SQL task from two objects in the Control Flow? Here is the flow of everthing:

    Execute SQL Task 1

    |

    |------Conditional Precedence ---> Execute SQL Task 2

    |

    |------Conditional Precedence ---> Data Flow Task ------ Success----> Execute SQL Task 2

  • December 9, 2013 at 10:00 am

    #1672038

    I can't really visualise your package, but try looking at the properties of your precedence constraint and make sure you've got the correct "Logical AND" or "Logical OR" chosen.

    John

  • December 9, 2013 at 10:06 am

    #1672042

    I agree with John's diagnosis.

    If you have multiple paths to a component and you want that component to fire when only one of those paths has successfully completed, you need to change the default 'logical and' to a 'logical or'.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • December 9, 2013 at 10:19 am

    #1672047

    Phil,

    That was it. I had to change the logical operator to "OR". Thank you both for the responses. I've read plenty about SSIS but have little experience with it. I figured it was something basic and I'm glad it was. Thanks again.

  • December 10, 2013 at 12:05 am

    #1672211

    No problem, happy to help - thanks for posting back.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply