Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Execute SQL Task not firing Expand / Collapse
Author
Message
Posted Monday, December 9, 2013 9:51 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Monday, June 16, 2014 11:58 AM
Points: 496, Visits: 816
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
Post #1521193
Posted Monday, December 9, 2013 10:00 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 2:40 AM
Points: 5,383, Visits: 9,953
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
Post #1521202
Posted Monday, December 9, 2013 10:06 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:56 AM
Points: 5,101, Visits: 11,901
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'.



Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this link.

When you ask a question (and please do ask a question: "My T-SQL does not work" just doesn't cut it), please provide enough information for us to understand its context.
Post #1521206
Posted Monday, December 9, 2013 10:19 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Monday, June 16, 2014 11:58 AM
Points: 496, Visits: 816
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.
Post #1521211
Posted Tuesday, December 10, 2013 12:05 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:56 AM
Points: 5,101, Visits: 11,901
No problem, happy to help - thanks for posting back.


Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this link.

When you ask a question (and please do ask a question: "My T-SQL does not work" just doesn't cut it), please provide enough information for us to understand its context.
Post #1521406
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse