DTS Probs

[Arijit Chatterjee]

Hi Everybody,
I am facing another probs. I have created a trigger for table Tab1 for
perticular column col1 for checking value ranges.But at time for using
insert statement it is working fine but when I am importing data from
flat file through DTS the trigger is not working.How to solve this.
Regards
Arijit Chatterjee

[Dan Guzman]

You can uncheck the 'use fast load' option in DTS so that triggers fire.

--
Hope this helps.

Dan Guzman
SQL Server MVP

-----------------------
SQL FAQ links (courtesy Neil Pike):

http://www.ntfaq.com/Articles/Index....partmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
-----------------------

"Arijit Chatterjee" <ar*****************@yahoo.co.in> wrote in message
news:ea**************************@posting.google.c om...

Hi Everybody,
I am facing another probs. I have created a trigger for table Tab1 for
perticular column col1 for checking value ranges.But at time for using
insert statement it is working fine but when I am importing data from
flat file through DTS the trigger is not working.How to solve this.
Regards
Arijit Chatterjee