sqlbulkcopy imports only 17837 out of 67000 rows

With the SqlBulkCopy class, you may import data from SQLite to SQL Server.

I'm trying to transfer the data from SQLite to SQL Server. The schema of target and destination table are just the same:...SQL Server:...CREATE TABLE [dbo].[Shop] ( [ShopID] [int] IDENTITY(1,1) NOT NULL, [Name] [nvarchar](128) NOT NULL, [Url] [nvarchar](128) NOT NULL, PRIMARY KEY CLUSTERED ( [ShopID] ASC )) ...and SQLite:...CREATE ...

SqlBulkCopy import causes primary key violations in SQL Server

I am trying to design a window based application in C#.NET. I am reading csv file in data grid view and then insert those data into database. I am using ...SqlBulkCopy... to insert data from csv file into database. My concern is, when I am trying to insert data into database (which already consist data) I am getting error of primary key constraint....

Importing XML data into a SQL database using sqlBulkCopy

I'm having proplems with importing an XML file using ...SqlBulkCopy.... The XML file looks like this:... <root> <Automobiles> <Car Id="1" Name="SomeModel1"/> <Car Id="2" Name="SomeModel2"/> <Car Id="3" Name="SomeModel2"/> </Automobiles> </root> ...My table looks like this:...Int Id varchar Name ...Her...

SQL Server import faster than bulk import

I have just spent the last few weeks fighting with the optimizing a very large load myself. BULK INSERT is the fastest way, I found with BCP, as opposed to SSIS or TSQL Bulk Insert, but there are things you can do to tune this. ...Try raising/lowering the rows per batch setting, to move resource pressure between CPU and memory (higher will reduce C...

SqlBulkCopy.WriteToServer(DataTable) row by row: very slow

I had to make application that imports a ...csv... file to database table. The ...csv... files are like ...~500rows...~30columns... and are from not very reliable source (might contain corrupted data)....I did it like this ...CSV->DataTable->SqlBulkCopy.WriteToServer(DataTable).... And it process 500 records to non-local sql server for about ...4 s...

Importing an Excel file with SqlBulkCopy fails

SqlBulkCopy is working perfectly on my local machine, but with the same xlsx file on server i am getting...External table is not in the expected format....or ...No error message available, result code: E_FAIL(0x80004005)....This excel file has more than 20.000 rows. But if i try with 4000 rows, it is working. ...My connection string is as below : ....

C# - Importing a CSV where empty strings do not get sent through bulk import to database

There are a multitude of solutions to get where you need....One problem I see is that if the person is uploading items with multiple rows and those rows have different data (say one column is blank on one row but filled in on a second row), that will cause it to break since the column will have deleted itself....SITE32,,1,2,,... SITE32,1,2,,,... ..

Problems importing into database from CSV and using SqlBulkCopy

I have a windows form application in which a user chooses a .csv file and clicks import. At this point the file should import into a SQL Server using SqlBulkCopy. Problem is I am getting some errors and I think its due to fields being empty on the import. Im getting this error:...Input string was not in a correct format.Couldn't store <> in ScranDr...

Importing a .CSV using SqlBulkCopy With ASP.Net Core

Hi I am trying to migrate some projects to ASP.Net Core and having some issues with what is the correct way to upload a .CSV file to my SQL database....In the past I would upload the .CSV file loop through it and store that information in a DataTable and then simply do a SqlBulkCopy.WriteToServer but I have found out that currently there is not a D...

Import Excel file into database using Epplus and Sqlbulkcopy in MVC 5

I am importing a large data file from excel into my database table using Epplus library in MVC5 and Entity Framework 6. It is taking alot of time to copy that file to the database. I am looking to use sqlbulkcopy to insert the data quickly but I am not really sure how to do that inside my controller. The code is working now but it takes alot of tim...