DTS

• sqlquery-101401

  SSCarpal Tunnel

  Points: 4951

  More actions

  December 3, 2003 at 6:16 am

  #59510

  my table contain more than 50 lacs of records

  but daily i dont require whole table record for different work ,is any way through dts i can select n no of records to transfer data in different tables,like at a time i want 1 million ,Plz suggest

• snikpoh

  SSCommitted

  Points: 1873

  More actions

  December 3, 2003 at 7:30 am

  #484444

  If you use a query statement in DTS rather than copying the object you could use top n to control the number of rows you are returning.

  Have a look at BOL for the different options.

  There is probably a better way !

  Hope this helps.