January 9, 2010 at 8:46 pm
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!
.
January 10, 2010 at 9:07 pm
The rowcount should work. The value of the variable will remain zero until the data flow task completes. Then it should contain the final count. You might check the level at which the variable is defined.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply