Hi...
Iam making a table which is getting its data from txtfile..
This table is getting data after every single minute.so iam doing this by executing a DTS
Now i want whenever this table gets data it execute a stored procedure which will create my second table..
but trigger is not working when dts execute ...and insert the records in first table...
Please helpp

You mention that the trigger on table1 is not working when you use DTS. There is an option called "use fast load" under the options tab on the transformation data task properties dialog. If you uncheck this you should find that your trigger now fires properly when using DTS.

Thanks,
Jeff