THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Rob Farley

- Owner/Principal with LobsterPot Solutions (a MS Gold Partner consulting firm), Microsoft Certified Master, Microsoft MVP (SQL Server), APS/PDW trainer and leader of the SQL User Group in Adelaide, Australia. Rob is a former director of PASS, and provides consulting and training courses around the world in SQL Server and BI topics.


Hi! - Great that you've found this page, but it's no longer here! You can find the content over at:

Published Thursday, August 29, 2013 1:32 AM by Rob Farley

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



csm said:

Hi Rob,

great idea, but it's important to note that by default, this doesn't work in SSIS because the default "Data access mode" option in an "OLE DB Destination" is "Table or view - fast load", which disable the triggers execution

To solve it, we can add "FIRE_TRIGGERS" option on "FastLoadOptions" in the advanced editor, or selecting "Table or view" on the "Data access mode" option

September 4, 2013 4:32 AM

Rob Farley said:

Yes - you do need to make sure that you're putting the data in using a method that will cause the triggers to fire.

September 8, 2013 11:22 PM

Rob Farley said:

Using a hammer to push in a screw isn’t a good idea, no matter how good the hammer is. We all know that.

September 9, 2013 8:24 PM

Leave a Comment


This Blog



No tags have been created or used yet.


News? Haven't you read my blog?

My Company

Can't find something?

Contact Me

Twitter: @rob_farley
Skype: rob_farley

MVP (SQL Server)


Adelaide SQL UG

Privacy Statement