SSIS insert bulk of data into remote table with trigger


hmmm, nice we have SSIS it makes life easier but it usually comes with non-understood problems like

“SQL Server Destination” (2185) failed with error code 0xC0202071 it means when you insert data into table in remote SQL Server don’t use SQL Server Destination component however use OLE DB Destination component, thank you SQL Server Central

Anyway I used OLE DB Destination component and everything went well but I found the trigger which updates something doesn’t fire simply because I do bulk insert and I should tell the BIDS please fire it.

So, right click on OLE DB Destination component then Show Advanced Editor… Component properties FastLoadOptions write FIRE_TRIGGERS

ssis postThank you Piotr Rodak

One Response to SSIS insert bulk of data into remote table with trigger

  1. […] This post was mentioned on Twitter by Duane Douglas, Ramy Mahrous. Ramy Mahrous said: SSIS insert bulk of data into remote table with trigger http://bit.ly/57GKs […]

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: