Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2011-07-12 : 04:59:04
|
| In execute sql task, I am doing an insert into ##tbl1This 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. 4000Why do you think I see two different results and the event viewer in ssis shows fewer rows please?Thanks |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2011-07-12 : 05:37:28
|
Because there already were about 1000 rows in the ##tbl1 table?The insert transferred 3000 rows, and with the already existing 1000 rows your final dataviewer displays 4000 rows.
N 56°04'39.26"E 12°55'05.63" |
 |
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2011-07-12 : 05:47:48
|
| Solved.It was to do with buffer size in dataviewer.Thanks |
|
|
|
|
|
|
returned data