Results 1 to 2 of 2

Thread: [RESOLVED] DTS and trigger

  1. Jul 27th, 2007, 03:13 AM #1
    sunshine123
    sunshine123 is offline

    Thread Starter
    Lively Member
    Join Date
    Apr 2007
    Posts
    83

    Resolved [RESOLVED] DTS and trigger

    Hi,

    Ive transfered data from an excel fil to sql server using DTS.

    The problem I have now is that when the table I transfered to has a trigger that executes when a row is added and inserts data into another seperate table. However, when transfering data using DTS, the trigger does not execute...any clues on how i could fix this....

    ps:manual insert fires the trigger fine.....

    thanks.....
    Reply With Quote Reply With Quote
  2. Jul 27th, 2007, 04:06 AM #2
    sunshine123
    sunshine123 is offline

    Thread Starter
    Lively Member
    Join Date
    Apr 2007
    Posts
    83

    Re: DTS and trigger

    by simply unchecking the "Use fast load" option under properties.....
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width