Search code examples
sql-serverssisssis-2008

Yellow on the control flow - No Color within the data flow; What's going on?


As the question suggests, I'm staring at a transformation that has several control flow elements, many of which are data flows.

Currently, one of the data flow objects within the control flow tab is lit up yellow. When I open that Data Flow object by double click or selecting the "Data Flow" tab, there are no boxes lit up in any color.

This would lead me to believe it's validating, perhaps?

Is there any way to tell what it's doing, and any steps to help make this process faster?

**Edit:

I took a look at the execution, and it looks like it's stuck in the Pre-Execute stage around 50%. Is there any optimization to be done for this stage.

Screenshot of the dataflow that isn't running. (This was taken while the control flow shows this data flow task as yellow)

enter image description here


Solution

  • I broke out each of these chunks into their own DF. One of these DFs was continuing to get stuck on the Pre-Execute stage. I ran the query for that OLE DB Source and found a long running query due to some dropped indexes. Replaced the index, and the transform stopped hanging.