Dear Members,

    I have a WebService (returns a dataset) method to Get the data from Remote server .

Now I have WindowsService , that will use that WebService to Get the data from the Remote Server and will insert those data to the local system database table.

As I have the table and also that table contains data that is present in local system.

So, how to insert those bulk data at one time to local system database, as the WindowsService calls the WebService in every 20 seconds.

What should i do in this case.Any advice would be greatly appreciated.

Dear Sowmya, Problem for inserting data will only exists whenever their is problem like Database is Down,n/w releated issues. Hence pls make sure your Query is fine and Logic is 100% proper and you are inserting proper data(Make sure you have increased DB size since you are storing Bulk data for every 20 sec.