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]

Re: DTS Probs

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.cfm?DepartmentID=800

http://www.sqlserverfaq.com

http://www.mssqlserver.com/faq

-----------------------

"Arijit Chatterjee" <arijitchatterj ee123@yahoo.co. in> wrote in message
news:ea01504d.0 311072112.52c56 ea3@posting.goo gle.com...[color=blue]
> 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[/color]