SqlBulkCopy Tutorial - Knowledge Base (KB)
27 results in tag: vb.net
What's the best way to use SqlBulkCopy to fill a really large table?
Nightly, I need to fill a SQL Server 2005 table from an ODBC source with over 8 million records. Currently I am using an insert statement from linked server with syntax select similar to this:...Insert Into SQLStagingTable from Select * from OpenQuery(ODB...
asked by Chad Braun-Duin
How to insert a DataTable with existing Key to a SQL Server Table
I am working with VB.NET.. i have a DataTable called "QUESTION", containing 3 fields:...QuestionNumber (unique integer key)...QuestionText...QuestionType...In my SQL Server database I created a Table called "QUESTION" with the same fields. QuestionNumber ...
asked by Olga
SQLBulkCopy does not work
This is my first attempt to use sqlbulkcopy class. When I run it, nothing happens, no errors whatsoever. Please help me....Here is my code:-...Imports System Imports System.Data Imports System.Data.SqlClient Imports System.Configuration.ConfigurationManag...
asked by rathu
bulk copy duplicating each row when it is added to database
Why is my bulk copy duplicating each row, so in my database table the row shows twice. ...Label1.Visible = True Dim tourid As New List(Of String) tourid.Add(TextBox1.Text) Dim tasktype As New List(Of String) Dim tourname1 As New List(Of...
asked by MyHeadHurts
XML to MS-Access 2007 using ASP.Net (Bulk Insert, Bulk Copy)
I am download a XML file comprising thousands of records. I want that XML file to convert it to MS-Access 2007 Database using ASP.Net (VB) and run further queries on it. Its worth mentioning that the conversion should be done in bulk because its very heav...
asked by Mehboob
Importing data using SQLBulkCopy
We have a legacy application that is dumping large volumes of data to tab delimited files. Each file contains a single record type and all fields are fixed length....These files can readily be imported into corresponding tables in our SQL server database ...
asked by Andy
sqlbulkcopy - does not allow DBNull.Value.?
I am trying these 2 calls below but both of them returns me an exception Customer_ID does not allow DBNull.Value. but when I debug, I see that all my records have Customer_ID assigned. It is the only one as not nullable defined on my DB table. what is cau...
asked by batmaci
SQLBulkCopy vs DataAdapter for inserting/update 10lcs records
I have around 1,000,000+ records that I want to insert into the database....Records having same Id should be updated else inserted...update/insert logic is written in Stored Proc...I'm using DataAdapter.Update method to do this work....Here is the problem...
asked by 1Mayur
Access double to SQL decimal using SQL Bulk Copy
I have an Access database that I am converting to an SQL database using sqlbulkcopy in vb.net. We have currency values (up to 2 decimal places) stored in Access as Double. When I convert these Access fields to SQL fields with type [decimal] (19, 2), a n...
asked by MPITech
SqlBulkCopy not working, no errors
I'm reading data from an Excel file or CSV. I take that data and create a datatable. I then merge that datatable with the datatable created from the original database. The merge works and I have already sorted out all of the datatypes and column names. I ...
asked by ZL1Corvette
BulkCopy Error" `The given value of type String from the data source cannot be converted to type int of the specified target column.`
I am trying to import data from CSV to DataBase usingBulkUpload, I am able to copy columns which are varchar but I am not able to import when I try to import integer column. Error:...The given value of type String from the data source cannot be converted...
asked by SamuraiJack
Keyword not supported: 'provider' with SqlBulkCopy
I try to write access connection string in SqlBulkCopy but I got error ...Keyword not supported: 'provider'...here is my code:...bulk = New SqlBulkCopy("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & mFileName & ";Jet OLEDB:Database Password=hmis;") bu...
asked by Mohammed Ahsan
Delete rows from DataTable in memory matching duplicate rows in Database
I have a dataTable which I will use to BulkCopy to a destination table. I am trying to resolve primary key violation. So instead of using a temp table and then merge with production, I am trying to delete the redundant rows from the DataTable in memory be...
asked by FrengiX
Overpassing SqlBulkCopy - Violation of Primary Key
I'm trying into upload to a database records in batches of 10 using SqlBulkCopy. Some of the data already exists in the destination table so, even if one record out of ten exists, the rest fail to get uploaded as well. Is there a way to upload the remaini...
asked by alwaysVBNET
Wanting to use a Progress Bar with SQLBulkCopy
Question on an app I'm developing using VB.NET. I'm wanting to use a progress bar to show the progress of my ...SqlBulkCopy... procedure. I've looked up some ways and was wondering if using an ...AddHandler... in my ...SqlBulkCopy... procedure, using ...S...
asked by Daniel Lemons
Using SqlBulkCopy for inserting to SQL
I don't know why data isn't getting into SQL. Can someone please review this and see what's wrong with my code? I got most of the code below from and MSDN page: ...http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlbulkcopy(v=vs.110).aspx....
asked by Aaron Hurst
Unable to compare SQL and datatable and copy new entries to sql table
I try to run a Left Join on my SQL Server 2012 database in VB.NET and I am stuck with this piece of code: ...Dim dtTabelle1 as DataTable (first Column of dtTabelle1 = Zyklus ID) Dim con As SqlConnection Dim conString, cmdString As String Dim cmd As SqlCl...
asked by Jonas
SqlBulkCopy Exception Doesn't Contain Column Name
If the DataTable passed into to SqlBulkCopy.WriteToServer() contains values that will fail to convert, I get an InvalidOperationException that displays the value that failed to convert. The column name doesn't display anywhere in the exception from what ...
asked by Bacon
Best method for importing data from text file into MS SQL Server
In need of your opinions. Currently developing an application in VB.NET. ...I have a text file which contains more than one thousand rows. Each rows contains the data needed to be inserted into the database. A sample of a row is as follows:...0001--------...
asked by Khairul
Excel to Sql adding certain rows to sql server
cmd.CommandText = (Convert.ToString("SELECT * From [") & excelSheet) & "] Order By" & columnCompany & "OFFSET 0 ROWS FETCH NEXT 100000 ROWS ONLY " ...I am trying to map data form excel to an sql table but the excel table has a lot of records in it, so I ...
asked by Richard
Page 1 of 2