SQL Trigger with DTS  
Author Message
bry32





PostPosted: Thu Sep 16 14:11:53 CDT 2004 Top

SQL Server >> SQL Trigger with DTS

I have a table that is updated via a DTS transform data task. This table has
a trigger on it to perform additional tasks when data is inserted.

When I manually insert into the table the trigger fires, but when the dts
job inserts into the table it does not fire.

Any ideas?

Thanks,

Mike

SQL Server57  
 
 
Tibor





PostPosted: Thu Sep 16 14:11:53 CDT 2004 Top

SQL Server >> SQL Trigger with DTS There's an option in DTS to not use "fast load", or "bulk load" or what the option is names, Makes
DTS to do regular INSERTs. Will be slower, of course...

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/



>I have a table that is updated via a DTS transform data task. This table has
> a trigger on it to perform additional tasks when data is inserted.
>
> When I manually insert into the table the trigger fires, but when the dts
> job inserts into the table it does not fire.
>
> Any ideas?
>
> Thanks,
>
> Mike
>
>


 
 
Mike





PostPosted: Thu Sep 16 14:21:07 CDT 2004 Top

SQL Server >> SQL Trigger with DTS Tibor,

Unchecking fast load worked.

Thank You!

Mike


 
 
Tibor





PostPosted: Thu Sep 16 14:27:19 CDT 2004 Top

SQL Server >> SQL Trigger with DTS FYI, Mike:

SQL Server actually have the option to fire triggers for bulk loading operations. But this is not
yet exposed in DTS. It is exposed in BCP and/or BULK INSERT, though...

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/



> Tibor,
>
> Unchecking fast load worked.
>
> Thank You!
>
> Mike
>
>