Post reply

How to increase DTS package limit in Sql Server 2005 .

  • March 19, 2009 at 7:18 am

    #207608

    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 provide me solution to solve this problem. Is there is any way to increase the Capacity of DTD package .

    Thanks,

    Alok

  • March 19, 2009 at 7:24 am

    #962667

    Are you using DTS in SQL 2005, or using SSIS?

    I'm not that familiar with DTS, but I can definitely say that SSIS can import much more than 27k rows.

    - 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

  • March 19, 2009 at 7:29 am

    #962673

    Yaah I am using SSIS .

  • March 19, 2009 at 7:34 am

    #962677

    Then it's probably either something wrong with the Excel file, or the Jet section of the registry on the machine you're running the SSIS package on.

    Try running the import on a different computer. Preferably one where you know that it has default settings.

    Failing that, someone who knows SSIS a bit better will need to look at the file and see if they can figure out what's wrong with it. If it contains proprietary information (anything business sensitive or with privacy issues), you'll need to work with management to work out what waivers/contracts/etc., that person will need to handle before viewing the file.

    - 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

  • March 19, 2009 at 7:38 am

    #962686

    Actually from that Excel sheet it inserting data randomly not in sequnce . I mean not as from the starting 26000 row .

    Thanks,

    Alok

  • March 19, 2009 at 7:43 am

    #962690

    Then the SSIS package isn't set up correctly, or there's something wrong with the Excel sheet.

    - 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

  • March 19, 2009 at 7:50 am

    #962700

    Thanks to reply .Yaah there must be some problem with Excel .

    Thanks,

    Alok

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply