I´m trying take tags from datalogger to sql Server 2022 and gets duplicates id

Hi,

You're getting duplicate rows in SQL Server because the trigger in your KEPServerEX DataLogger is staying TRUE for more than one scan cycle. While it's TRUE, the logger is recording the same data repeatedly.

To fix this, you can try one of the following:

1. Set “Log All Items” to No so it only logs when the value changes.

2. Change the trigger to create a short pulse—make the tag TRUE for one cycle only, then FALSE. This way, it logs only once per event.

3. If you want to keep the current setup, add a timestamp or auto-increment column in SQL Server so each row is unique.

4. You can also handle duplicates at the database level using a view or filtering logic.

The cleanest solution is to trigger logging with a short one-time TRUE condition or enable logging only on change.

Thanks,