Post reply

Generating PK while performing data loads

  • April 16, 2005 at 10:44 pm

    #165267

    hi,

    I am loading data from XLS file into DB using DTS. I have to generate a primary key for each row being inserted. The PK is just a sequence staring from 1 but is not present in the xls file. I used a identity column to generate the PK but my DTS package does not work because the PK is not picked from the file. Any ideas or suggestions about what i might be doing wrong?

    Thanks in advance

    Adi

  • April 17, 2005 at 8:28 pm

    #553069

    In the transformations, exclude the identity column, and on the Options tab make sure "Enable Identity Insert" isn't checked. Then the sequence numbers will be automatically incremented.

     

     

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

  • April 18, 2005 at 7:29 pm

    #553306

    Thanks a lot Phill works  like a charm now

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

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