Data missing on running in a procedure

Question

Hello Every one,

One of my vender send data to my server from different ports nearly 1000 records for every 30 secs. By lisener in C# Iam inserting the data into textfile and in sql server table by stored procedure (ADO.NET). The data gets inserted in txtfile completly but the data seems to missing in the table. and the service also seems to off periodically.

Any help please.

What I have tried:

Tried sync by creating tasks in C# side. But no use in sql server side