Post reply

DTS and Excel (NULL values) issue

  • May 3, 2005 at 3:18 pm

    #61131

    Hi

     

    I have a package tht loads an excel file to a table. Simple and works just fine.

    Let's say my excel file has 10 rows and i run the dts and 10 rows get loaded.

    Now, 2nd time i open the excel file and delete last 8 rows and retain only first 2 rows and save the file. I run the DTS package again and it says 10 rows loaded again.. when i see the table, NULL is loaded in the rest of the 8 rows..

    how can avoid this..? please let me know.

    Thanks for the help

    THNQdigital

     

     

  • May 3, 2005 at 4:45 pm

    #556639

    Did you just clear the eight rows or explicitly delete them? I've had problems like this previously where people where just highlighting what they wanted to remove and pressing delete. Thinking in terms of a database table, this doesn't remove the rows, it just removes the data in them.

     

    --------------------
    Colt 45 - the original point and click interface

  • May 4, 2005 at 3:18 am

    #556691

    This should explain a couple of things.

    http://www.sqldts.com/default.aspx?6,222,254,0,1

    Howard.

  • May 4, 2005 at 9:27 am

    #556813

    Hey Phill.. you are the man.. thanks.. that was the problem.. i was only deleting the data not the rows in excel.. Thanks..

    Thank you Howard for the informative URL..

    I have an idea.. If i don't care about how JET treats excel, i can have another step just after loading the data in to a table, which basically checks if any row has all the values as null.. if yes fire a delete.. how ab't that..?

    But i know if the table has many columns then it may be a bit tiriing to check all the columns for null .. just an idea though..

    Thank you guys

    THNQdigital

     

     

     

Viewing 4 posts - 1 through 3 (of 3 total)

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