Hello!   I'm a new syslog-ng user, so please be gentle with me.  :)

I'm attempting to log to an MS-SQL database and would like to send to different tables in the same DB based on the source IP - for example device A to its own table, device B to its own table, and so on.

I thought I would simply need to create the same destination but define different table names in each, it works, however under load the syslog-ng service starts restarting over and over and eventually MS-SQL errors and alerts that the login packet is structurally invalid.

Is it possible to send to different table names in this manner or is there another way to do it?

Thanks!