How to increase capacity of DTS package.

• alokkumar_srivastava

  Mr or Mrs. 500

  Points: 508

  More actions

  March 19, 2009 at 7:10 am

  #129904

  Hi All,

  I am facing problem during insertion of data from Excel sheet through DTS package in sql server 2005 , it not inserting all row from Excel sheet.In Excel sheet i have around 50,000 row .It inserting only 27000 rows.Please help me.

  Thanks,

  Alok

• GSquared

  SSC Guru

  Points: 260824

  More actions

  March 19, 2009 at 7:25 am

  #962670

  Don't double-post. Post the question in one forum on the site, please.

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon