sql server - Why don't all my SSIS parallel tasks execute? -


i have data flow task followed 3 tasks in ssis 2012 package control flow. part of data flow rowcount transform sets user::rowcount number of rows passed data source target. after exiting data flow there 3 tasks:

  1. an email task - task runs if success , user::rowcount>$project::rowcount_threshold. task runs , email (threshold set 1 testing email).

  2. a second email task - task runs if secondary task within data flow detects rows value exceeds different threshold. if count of "issues" (another user variable) exceeds $project:issue_threshold email. condition executing task success plus comparison of issue_count issue_threshold. doesn't run , shouldn't since i've set threshold high right now.

  3. the final task takes user::rowcount , inserts log table via execute sql task simple parameterized sql insert. task runs based on success should run every time.

my problem when run package data flow runs, user::rowcount set number of rows inserted in target when data flow completes first task runs. email # of rows inserted. second task shouldn't run based on conditions , doesn't. third task should run never does. no messages, doesn't run.

these tasks configured parallel tasks following data flow task.

i've tried haven't been able figure out why task #3 isn't running. ideas?

picture of data flow , following tasks:

enter image description here

the log record count task execute sql task isn't running.

i'll add answer: looks log record count disabled. see how it's little grey

i have tell not monitor, it's hard see difference. ssis team did great job improving debug icons usability, disabled thing needs more obvious. put in connect , i'll vote.

m


Comments

Popular posts from this blog

java - Plugin org.apache.maven.plugins:maven-install-plugin:2.4 or one of its dependencies could not be resolved -

Round ImageView Android -

How can I utilize Yahoo Weather API in android -