Very Computer

hi
I am working on MS SQL7 and have designed a package in the
package designer. This package mainly transfers as well as
transforms data from one database at a geographically
distant location and puts them in my database. That part
is simulated with both the databases on a my machine. Now
my problem is after the package is executed succssfully
the data is inserted into 3 import tables, and i wish to
write triggers ( includes business logic) on all these 3
tables after successful transfer of data into the import
tables. The 3 triggers written are based on after Insert
statement but they dont get triggered at all. But running
a separate SQL insert statment in the import tables the
triggered gets fired.

Please help
Cheers
Sid

Uncheck the "Use Fast Load" option of your data pump tasks (Options tab).
Triggers should then fire.

Cheers,
Chris

Quote:> hi
> I am working on MS SQL7 and have designed a package in the
> package designer. This package mainly transfers as well as
> transforms data from one database at a geographically
> distant location and puts them in my database. That part
> is simulated with both the databases on a my machine. Now
> my problem is after the package is executed succssfully
> the data is inserted into 3 import tables, and i wish to
> write triggers ( includes business logic) on all these 3
> tables after successful transfer of data into the import
> tables. The 3 triggers written are based on after Insert
> statement but they dont get triggered at all. But running
> a separate SQL insert statment in the import tables the
> triggered gets fired.

> Please help
> Cheers
> Sid