If you are writing this in C# you might want to look at the SqlBulkCopy class.
Lets you efficiently bulk load a SQL Server table with data from another source.
More Related Contents:
- How can I insert 10 million records in the shortest time possible?
- SqlBulkCopy from a List
- SQL Server Char/VarChar DateTime Error [closed]
- How can I solve error in connection string in C#?
- Monitor all print queue job
- Best Timer for using in a Windows service
- Allow Windows service to interact with desktop
- Remove weird characters ( A with hat) from SQL Server varchar column
- How do I get the currently-logged username from a Windows service in .NET?
- Service hangs up at WaitForExit after calling batch file
- Why should I use int instead of a byte or short in C#
- How to deploy application with sql server database on clients
- Inno Setup for Windows service?
- What represents a double in sql server?
- How to catch SQLServer timeout exceptions
- Use of SqlParameter in SQL LIKE clause not working
- Is there any way to embed power bi reports and dashboards in vb.net or C# desktop application with sql server 2008 database?
- How can I retrieve a list of parameters from a stored procedure in SQL Server
- Automatically start a Windows Service on install
- DateTime’s representation in milliseconds?
- What’s the best way to test SQL Server connection programmatically?
- Entity Framework 6 transaction rollback
- Reading Excel Files as a Server Process
- Using SqlDataAdapter to insert a row
- Start a windows service and launch cmd
- How to pass string array in SQL parameter to IN clause in SQL
- Horrible performance using SqlCommand Async methods with large data
- Should the order of LINQ query clauses affect Entity Framework performance?
- How do I connect to a SQL database from C#?
- Run a process from a windows service as the current user