Execute SQL Task not firing

Question

Execute SQL Task not firing

AVB

SSChampion

Points: 11418
More actions
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

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

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

John Mitchell-245523 SSC Guru Points: 148809 More actions · Answer 1

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

Phil Parkin SSC Guru Points: 246695 More actions · Answer 2

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

If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

AVB SSChampion Points: 11418 More actions · Answer 3

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.

Phil Parkin SSC Guru Points: 246695 More actions · Answer 4

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

If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.