Triggers

[Sagar Malte]

I an loading records from a flat file into a table, which is done everyday by a scheduled job in SQL Server 7.0.

How can I make sure that if the job is run twice in a day for some reason that the same rows are not inserted into the table again? Do I have to write a insert trigger on the table ??? If so how can I achive the objective ??

[Mohammed.]

I think it is not good idea to use trigger. Use XP_filedetails and check the results set the condition the logic to insert into the table from flat file...

Thanks,
Mohammed.


------------
Sagar Malte at 1/11/2002 11:00:27 AM


I an loading records from a flat file into a table, which is done everyday by a scheduled job in SQL Server 7.0.

How can I make sure that if the job is run twice in a day for some reason that the same rows are not inserted into the table again? Do I have to write a insert trigger on the table ??? If so how can I achive the objective ??