SSIS and Insert Triggers

Hot Topic

Import/Export data with SQL Server 2005 Express
Sept 64bit Enterprise CTP Client Tools issue
Freeze Panes?
Export data to Excel file is very big files.
ERROR: SQL Server does not exist or access denied
How to Store System Variables in DB?
Reporting Services Setup Issue
Some strange problems
No snapshot automaticly updated
Problems with LOOKUP component (repost)

SQL Server

SQL Server Configuration Manager
Debugging a script component task???
storing values
SQL Server 2005 Remote Connection Problem... Big Time.
Create XML file with SS Management Studio Express
How to export data from stored procedure source?
Don't email report if no results from query
How to store a complex query result somewhere and refresh it hourly/daily/on demand?
Referencing SQLDMO in UNSAFE assembly
CAST error

SSIS and Insert Triggers

I have created a simple data import package using the SSIS Import and Export Wizard in Visual Studio 2005. All done in a bout 2 min. great stuff.

But the table I am importing into has an insert trigger which is not get fired by the package. The wizard created a Data Flow task which doesn't seem to have any properties to turn triggers on.

Do I have to export to a flat file and then re-import using a Bulk Insert Task

TIA Steve

Answer this question

SSIS and Insert Triggers

  • John Berchmans

    In the data flow task, I am assuming the Destination is an OLEDB Destination. Go to the Advanced Editor, and there should be a property "FastLoadOptions". Specify FIRE_TRIGGERS as an additional option. That would cause it to fire triggers.

    HTH,
    thanks
    Ranjeeta

  • SSIS and Insert Triggers
Answer this question