Inside a Data Flow task, I have an OLED DB source that is based on a query. It ouputs data to an OLE DB destination which is connected to a central DB. Works great. I need to know how many rows were loaded though, and I can't seem to get the RowCount Transformation to work they way I expect. I dropped a RCT between the source, and the destination, set it's output variable, gave it access to the variable it needed to change, but it seems to always output 0.
1.) Am I doing something wrong here?
2.) Is there a better way to get a row count in this scenario?
Thanks as always!