I have a dataflow inside a FOREACH that never gets touched during test execution. I have all kinds of breakpoints set on it, I have a script task immediately before it for debugging purposes, that ALL IT DOES is to messagebox() the same element that the dataflow uses--and it (the script task with the messagebox) works just fine.
Execution marches right past this dataflow. No errors thrown, nothing. I've also seeded it with calls to messagebox()...nothing.
This is so weird that I'm not going to start off with the code of the dataflow itself, just because at this point, I think what it actually contains is immaterial. I think the whole damn thing is being ignored, for some reason I cannot understand.
How else would you explain that its OnPreExecute() and OnPostExecute() breakpoints, plus, several others, are never touched? Bear in mind that these are not custom breakpoints that are inline, in the code. I'm talking about the general ones that SSIS allows you to set.
Weird. What is happening? Why is my dataflow so thoroughly ignored?