SSIS OLEDB Destination Options

Question

Post reply

SSIS OLEDB Destination Options

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

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

Revenant SSC-Forever Points: 42467 More actions · Answer 1

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

BarbW SSCarpal Tunnel Points: 4759 More actions · Answer 2

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

Britt Cluff SSCertifiable Points: 5083 More actions · Answer 3

Good question. Thanks.

http://brittcluff.blogspot.com/

TomThomson SSC Guru Points: 104773 More actions · Answer 4

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 More actions · Answer 5

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