Thansk you Steve, the link http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/2a5f460b-8684-4510-8fcb-1e9d9786baff

worked for me.

I needed to include a left join in the dataset query and create a matrix. The left join was required so I can extract the full set of values to...

It's been sometime since your post, but this was the best solution I found today for this issue. Only thing is if you have a group subtotal the subtotal will...

http://www.programmersedge.com/?p=1492

I'm having same issue, row count doesn't perform as we expect.

Thank you snaghshineh, really appreciate your reply. Changed my DTS package a number of times thinking it was a temp table issue.