Forum Replies Created

Viewing 15 posts - 31 through 45 (of 62 total)

  • RE: Trigger Performance

    How do I get the identity column values from the errorPK table?

  • RE: Trigger Performance

    As you mentioned, the proc and trigger are equivalent in a bulk usage scenario. The trigger gets fired more often, though, depending on settings. The performance of the...

  • RE: Trigger Performance

    vishal.gamji (3/8/2011)


    Working on it.

    Although - shouldn't ssis be faster as bulk insert would be much faster than single row inserts?

    Except that if you use fast load, and set the...

  • RE: Trigger Performance

    Doesn't a trigger have the same performance of a Stored Procedure though?

    And when I can make the trigger fire once after all my insterts is done, wouldn't this make the...

  • RE: OLE DB Destination and Triggers

    Thank you very much sir!

  • RE: OLE DB Destination and Triggers

    That thread is talking about why the trigger wasn't firing at all. I know with fast load it doesn't trigger, which is why I specified the regular load.

    What I want...

  • RE: Trigger Performance

    I need to insert rows into the table I am referrencing too within the same package.

    I need to insert rows into error table. Error table has an identity column primary...

  • RE: Test, fail, wait-a-while, test again

    WHILE TestIsFalse

    BEGIN

    MoreLogicHere

    WAITFOR DELAY '00:05:00'

    END

  • RE: Stored Proc to send an Email?

    thanks guys!

  • RE: Error Redirection

    Oh right ok, yeah the information is definitely there. I just needed to know how I can format it to be like:

    Error Message | Column Causing Error | Value of...

  • RE: Error Redirection

    Yes that's what I am trying to get. What do you mean error path?

  • RE: Derived Column

    Ah ok, great thanks!

  • RE: Derived Column

    The value coming is not a string, is an interger. It gives me a data conversion error.

  • RE: capturing Error Column

    This is perhaps a stupid question, but when you add a custom component, do you just need to add it on your computer or do you need to add...

  • RE: Error handling

    SQLkiwi (2/26/2011)


    Khades (2/25/2011)


    I need to dump some rows into a staging table. However I want sql server to continue with the rest of the rows when 1 or more...

Viewing 15 posts - 31 through 45 (of 62 total)