SqlBulkCopy Tutorial - Knowledge Base (KB)

SqlBulkCopy multiple tables in ASP.NET MVC unblockable

I have to make a multiple copy of tables from one database to other with SqlBulkcopy from an ASP.NET MVC application....The process takes more than 2 minutes, and I do not trust users....Wich is the best way to do the entire process, even if the user clos...

Using SQL Bulk Copy to fill a database table

I'm working on an web app using ASP.NET MVC4. I have an Excel file with several columns (some of them are useless) and I'd like to export the data to a related table by uploading the file....One of my superiors told me to use SQL Bulk Copy to do that. I s...

Cannot SQLBulkCopy Error 40197 with %d code of 4815 (Connection Forcibly Closed)

Developing with VS 2013 ASP.NET MVC 5 Web Project and Separate Azure hosted SQL Server database. ...At the bottom is all my error information from Visual Studio 2013. I've narrowed down the problem and found a link to the Microsoft Description of the prob...

Sql bulkcopy error - The given ColumnMapping does not match up with any column in the source or destination

I am trying to sqlbulkcopy to my sql table. My source that is the datatable has three columns and destination table has four columns the first column being idendity column. The destination table generates the values when record is inserted to the database...

SQLBulkcopy - Header of datatable getting inserted in the database table

The header of the datatable is getting inserted as a record in the table. I am incrementing the row number but still the header gets inserted. Could someone tell me what the issue is ? If you see the code below the I am doing rows.MoveNext.... XSSF...

"The ConnectionString property has not been initialized." Error in SQL bulkcopy upload

I just created mvc 4 application,in that application I have function to upload Excel File to the database....this is working fine in localhost ....But when I deploy in ...IIS... and try to upload excel file.I'm getting following error ...The ConnectionStr...

How do I optimize data import into SQL Server with 100000 records with 100s of concurrent users

I am using Visual Studio web application using ASP.NET MVC & C#. I have an Excel file of more than 100000 records for import into SQL Server 2008 R2....I have used ...SqlBulkCopy... with ado.net ...DataTable... to copy data to a table (...Table1...)....Th...