January 7, 2009 at 11:23 am
Simple SSIS data flow. The known results from the merge join is 86,000 rows. The merge join will return anywhere from 900 rows to 8600 rows after 20 plus executions. It never returns the same number of rows. Why?
January 7, 2009 at 11:27 am
Hard to say. No data or logic to look at to be able to know what is actually happening.
January 7, 2009 at 12:19 pm
barbaran (1/7/2009)
I attached an image of the data flow.SELECT Key
FROM databaseA.tableA (400,000 rows)
SELECT Key
, value
FROM database1.table1 (1,200,000 rows)
MERGE JOIN ON Key
86,000 records are known to match, the number of rows returned is never the same and never 86,000 rows.
The image isn't the logic. There is nothing there for us to see how the data is being joined. There is no data for us to look at and see what is going on either. What is the structure of the data being read, how do the tables relate? Again, the data flow image doesn't provide any of that.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply