I have problem in MS SQL 2008 R2 Enterprise version.
I am trying to use Data Flow Task (in DTS) to write in prediction querry results into the table. My input table has about 4000000 rows. When I try to execute task I obtain different result at each time. Once the output table has about 2000000 rows and once
3000000 (at each time DTS component turn to green color - complete with succes). Always the output table has less rows than the input table.
I have checked the querry (dmx) in visual studio and managment studio (with displaying the results on the screen) - at each time it works fine, number of displayed rows is the same as the number of rows in the input table (in the prediction join).
I have done it before in MS SQL 2005 Enterprice version and I did not observe any problems
What could be the problem?
View Complete Post