DTS Probs
This is a discussion on DTS Probs within the SQL Server forums, part of the Microsoft SQL Server category; --> Hi Everybody, I am facing another probs. I have created a trigger for table Tab1 for perticular column col1 ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 07:43 PM
| ||||
| ||||
 DTS Probs 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      |
|
02-28-2008, 07:43 PM
| ||||
| ||||
| 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....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 |
 |
« how to bring back the distinct values in single column from two tables
|
File Copy to Windows 2000 from NT server running sql7 »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 10:09 AM.
