Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2002
    Location
    BC Canada
    Posts
    61

    Unanswered: Help!! - BCP / Bulk Copy

    I need top update several tables with new values from an external text file. That would notrmally be a no brainer, (even for me) But, what is important this time around, is I can NOT fire the triggers, or every user would get notified of a 150,000 updates.

    The text file contains 4 fields
    KEYNUM|UpdateField1|UpdateField2|Class

    Class will be either 1 or 2, if class = 1 then table 1 contains the record, if class = 2 then table 2 contains the record...

    Any help, as always is greatly appreciated

  2. #2
    Join Date
    Feb 2003
    Location
    Brisbane, Australia
    Posts
    110

    Re: Help!! - BCP / Bulk Copy

    Hi,

    By default BCP does not fire triggers, it will only fire triggers if you use the FIRE_TRIGGERS hint.

    Does that change anything or help?

  3. #3
    Join Date
    Oct 2002
    Location
    BC Canada
    Posts
    61

    Re: Help!! - BCP / Bulk Copy

    Originally posted by bmalar
    Hi,

    By default BCP does not fire triggers, it will only fire triggers if you use the FIRE_TRIGGERS hint.

    Does that change anything or help?
    That Part I knew (but thanks). How can I use bcp to update selected records? (i.e. update records based on values in the KEYNUM field)

  4. #4
    Join Date
    Feb 2003
    Location
    Brisbane, Australia
    Posts
    110

    Re: Help!! - BCP / Bulk Copy

    Originally posted by GregCrossan
    That Part I knew (but thanks). How can I use bcp to update selected records? (i.e. update records based on values in the KEYNUM field)

    Sorry I didn't read your post correctly.. I thought you were inserting new records.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •