In execute sql task, I am doing an insert into ##tbl1 This is a global table that I am inserting into. Using a dataflow with a dataviewer, I see that there are about 3000 records inserted into this global table... In another dataflow using another dataviewer, I run the select query which I used previously to do the insert into the global table but the dataviewer shows that there are about 4000 records returned and not 3000 as previously mentioned. If I run the select query in a query analyser I see 4000 records which are correct number of rows. BUT, it seems that if I do a select * from the global table, then it does show the correct number of rows i.e. 4000 Why do you think I see two different results and the event viewer in ssis shows fewer rows please? Thanks

It may be that SSIS can only fit 3000 rows in the buffer, and the other 10000 rows are in a second buffer. If you press play on the dataviewer, does it show buffer 2? It will show the buffer number at the botton of the dataviewer window.Peter Carter http://sqlserverdownanddirty.blogspot.com/

Hi, Data Viewer does not show all the records,That's why you see few of them even more records are inserted. There is button that you can press to see next records... but just in first display it shows some records not all of them. Thankshttp://sqlage.blogspot.com/

Well done. It was the Buffer. Many thanks

yes. Thanks