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:
an email task - task runs if success , user::rowcount>$project::rowcount_threshold. task runs , email (threshold set 1 testing email).
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.
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:
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
Post a Comment