zzz projects SqlBulkCopy Tutorial
Documentation Troubleshooting
Knowledge Base
  • Documentation
  • Troubleshooting
  • Knowledge Base

SqlBulkCopy Tutorial - Knowledge Base (KB)

27 results in tag: vb.net

What's the best technique to populate an extremely big table using SqlBulkCopy?

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...
.net c# sqlbulkcopy sql-server vb.net
asked by Chad Braun-Duin

How to put a DataTable into a SQL Server Table with an Existing Key

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 ...
database datatable sqlbulkcopy sql-server vb.net
asked by Olga

SQLBulkCopy isn't working.

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...
sqlbulkcopy vb.net
asked by rathu

When each record is added to the database, bulk copy duplicates it.

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...
asp.net sqlbulkcopy vb.net
asked by MyHeadHurts

ASP.Net to MS-Access 2007 conversion (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...
asp.net sqlbulkcopy vb.net xml
asked by Mehboob

Using SQLBulkCopy to import data

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 ...
sqlbulkcopy vb.net
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...
sqlbulkcopy vb.net
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...
.net dataadapter performance sqlbulkcopy vb.net
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...
ms-access sql sqlbulkcopy vb.net
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 ...
c# datatable sql sqlbulkcopy vb.net
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...
.net sqlbulkcopy vb.net
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...
asp.net c# ms-access sqlbulkcopy vb.net
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...
.net datatable sqlbulkcopy sql-server vb.net
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...
sqlbulkcopy sql-server vb.net
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...
progress-bar sqlbulkcopy vb.net
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....
sqlbulkcopy sql-server vb.net
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...
datatable sql sqlbulkcopy sql-server vb.net
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 ...
.net exception sqlbulkcopy vb.net
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--------...
performance sqlbulkcopy sql-server vb.net
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 ...
excel sql sqlbulkcopy vb.net
asked by Richard

Page 1 of 2
  • 1
  • 2
  • ยป

Prime Library

Performance

  • Entity Framework Extensions
  • Entity Framework Classic
  • Bulk Operations
  • Dapper Plus

Expression Evaluator

  • C# Eval Expression
  • SQL Eval Function
More Projects...
Get monthly updates by subscribing to our newsletter!
SUBSCRIBE!