SSIS OLEDB Destination Options

  • Revenant

    SSC-Forever

    Points: 42467

    Thanks for the question, Craig! Especially when it is about SSIS! 🙂

  • BarbW

    SSCarpal Tunnel

    Points: 4759

    Wow, right now the responses are running 50/50. That is a good question and I learned something too!

  • Britt Cluff

    SSCertifiable

    Points: 5083

    Good question. Thanks.

    http://brittcluff.blogspot.com/

  • TomThomson

    SSC Guru

    Points: 104773

    Good question.

    I thought that firing triggers would be on by default in a fast load (no real reason for thinking that, it just seemed reasonable) but there might be an option to turn them off, so I picked the right answer despite my ignorance - learnt something new.

    Tom

  • Evil Kraig F

    SSC Guru

    Points: 100851

    L' Eomot Inversé (1/19/2012)


    Good question.

    I thought that firing triggers would be on by default in a fast load (no real reason for thinking that, it just seemed reasonable) but there might be an option to turn them off, so I picked the right answer despite my ignorance - learnt something new.

    Just for future reference, Fast Load = Bulk Insert, roughly.


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • Paul White

    SSC Guru

    Points: 150442

    Good question, Craig, and not even remotely evil 🙂

  • Jagadish Kumar Punnapu

    SSChasing Mays

    Points: 645

    Nice Question... Thanks...

  • Koen Verbeeck

    SSC Guru

    Points: 258985

    Awesome question. It was about time there was a new QotD for SSIS.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Bhushan Kulkarni

    SSCrazy

    Points: 2829

    Learned something new

Viewing 9 posts - 16 through 24 (of 24 total)

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