开发者

How do I view all the rows in a data viewer?

开发者 https://www.devze.com 2022-12-19 12:15 出处:网络
I have a data viewer attached to a data flow transformation to show me the incomi开发者_StackOverflow中文版ng data in grid format. At the bottom of the grid, I see total rows as 22,002 but only 9,964

I have a data viewer attached to a data flow transformation to show me the incomi开发者_StackOverflow中文版ng data in grid format. At the bottom of the grid, I see total rows as 22,002 but only 9,964 are rows displayed on the grid. How do I view the remaining rows in the data viewer? I've tried clicking and right-clicking on the data viewer but with no luck!


In the data flow, SSIS pulls the data from your source into separate buffers which it manages separately down the data pipeline. In order to see the next buffer, you click the little play button in the top left hand corner which will then give you the second buffer. The number of rows displayed can be the same or different. By doing some quick math, SSIS probably generates about 2-3 buffers for you. You can easily copy and paste the data contained in each buffer by clicking the copy data button in the top right hand corner. I hope this clears up any confusion you had viewing data using the data viewer.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号