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

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" <arijitchatterjee123@yahoo.co.in> wrote in message
news:ea01504d.0311072112.52c56ea3@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