top n rows in BIDS

• spectre

  SSC Rookie

  Points: 41

  More actions

  October 18, 2010 at 8:02 am

  #143187

  Hi,

  Anyone can tip me how I can keep top 5 rows in a datastep based on a value in a colum?

  Im using BIDS 2008 R2

  Thanks

• Koen Verbeeck

  SSC Guru

  Points: 259115

  More actions

  October 20, 2010 at 3:10 am

  #1239533

  Can you be more specific?

  You are using SSIS right? What are you trying to accomplish?

  I believe it is worth taking a look at the following URL:

  http://msdn.microsoft.com/en-us/library/aa259187(SQL.80).aspx

  Look at the section explaining TOP.

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP