SqlBulkCopy Tutorial - Knowledge Base (KB)
641 results
On SQL Server 2000, SqlBulkCopy creates a deadlock.
I have a customized data import executable in .NET 3.5 which the SqlBulkCopy to basically do faster inserts on large amounts of data. The app basically takes an input file, massages the data and bulk uploads it into a SQL Server 2000. It was written by a ...
asked by stevenjmyu
BulkCopy in SQl Questions
I am wondering how can do a mass insert and bulk copy at the same time? I have 2 tables that should be affect by the bulk copy as they both depend on each other. ...So I want it that if while inserting table 1 a record dies it gets rolled back and table 2...
asked by chobo2
In C#, how can I enter a null value for a datatable's numeric field?
Consider My dynamically generated datatable contains the following fileds ...Id,Name,Mob1,Mob2...If my datatable has this it get inserted successfully,...Id Name Mob1 Mob2 1 acp 9994564564 9568848526 ...But when it is like this it gets failed sa...
asked by ACP
Why is sqlbulkcopy behaving strangely in an asp.net website based on IIS?
I'm using ...SqlClient.SqlBulkCopy... to try and bulk copy a csv file into a database. I am getting the following error after calling the ..WriteToServer method...."The given value of type String from the data source cannot be converted to type decim...
asked by ACP
Is it possible to recover PrimayKey IDs after a SQL BulkCopy?
I am using C# and using SqlBulkCopy. I have a problem though. I need to do a mass insert into one table then another mass insert into another table....These 2 have a PK/FK relationship....Table A Field1 -PK auto incrementing (easy to do SqlBulkCopy as str...
asked by chobo2
How can I locate the problematic column? Converting from string to int32 is not possible.
I am using SqlBulkCopy. So I made a datatable and specifed it's columns then added rows to the datatable and then try to insert it....System.InvalidOperationException was unhandled by user code Message=The given value of type String from the data ...
asked by chobo2
SqlBulkCopyColumnMappingCollection: How to Use
I want to make one SqlBulkCopy method that I can use for all my bulk inserts by passing in specific data through the parameters....Now I need to do mapping on some of them. I don't know how to make a SqlBulkCopyColumnMappingCollection since that was my pl...
asked by chobo2
SQL Server 2008 database: insert relational(normalized) data tables quickly
I'm trying to find a better and faster way to insert pretty massive amount of data(~50K rows) than the Linq that I'm using now. The data I'm trying to write to a local db is in a list of ORM mapped data serialized and received from WCF. I'm keen on using ...
asked by TheBoyan
Could managing errors with SqlBulkCopy be any more difficult?
Running very low on ideas here. I've got a case where I'm using SqlBulkCopy to pump data into a DB, and about halfway through I run into different exceptions (primary key violations, index violations, etc)....I've confirmed that the violations are in fact...
asked by David Catriel
Byte with SqlBulkCopy[] Error in DataTable column
I have a strongly typed dataset containing a datatable with one of the columns as a byte[] column that I'm trying to insert into a binary(4) database table field. I'm able to set the byte[] column values without any problems, but I receive the following ...
asked by Flahrty
What is the best way to get SqlBulkCopy to function with MS Enterprise Library?
I've got some code which uses SqlBulkCopy. And now we're refactoring our code to use Enterprise Library database functions instead of standard ones. The question is how can I instantiate SqlBulkCopy? It accepts SqlConnection, and I only have DbConnection....
asked by HiveHicks
management sqlbulkcopy mem
I'm using SQLBULKCOPY to copy some data-tables into a database table, however, because the size of the files I'm copying run sometimes in excess of 600mb, I keep running out of memory....I'm hoping to get some advice about managing the table size before I...
asked by jordan.baucke
How can I resolve this stored procedure issue?
I have 2 tables. The following are just a stripped down version of these tables....TableA Id <pk> incrementing Name varchar(50) TableB TableAId <pk> non incrementing Name varchar(50) ...Now these tables have a relationship to each other. ...Scenario...Us...
asked by chobo2
XSD: Table y's type of column x is too tiny to store data
I am generating an XSD file based on the columns in my xml. I give them all the type, "xs:string". Then I try to import the file into my database using .NET with SQLbulk import, but for some fields are to small. I get the message, "type of column x in ta...
asked by Ivo
SqlBulkCopy skips certain columns.
I'm using ...SqlBulkCopy... against two SQL Server 2008 with different sets of columns (going to move some data from ...prod... server to ...dev...). So want to skip some columns not yet existed / not yet removed....How can I do that? Some trick with ...C...
asked by abatishchev
Is it possible to transfer data across servers using sql bulk copy?
Can I use sql bulk copy to copy data within the same server ?
asked by Relativity
In.Net, how can I bulk transfer sql (export) tables to csv or tsv files?
Are there any .Net libraries that provide a way of exporting sql database data to plain text files (i.e. csv\tsv)? SqlBulkCopy only applies to the import part of the solution and I prefer not to be calling any Process.Start calls to open up command prompt...
asked by JK.
Attempting to duplicate a row with significant content in an XML column using SqlBulkCopy fails.
I am trying to copy a record from one SQL Server table to another. Both tables have the same structure, one of the columns is of type xml. Source table has a large xml content in of the rows, about 2.5Mb....I saved the content of the xml column into a fi...
asked by stask
Is it possible for SqlBulkCopy to construct a table from a SQL selection?
Can SqlBulkCopy create a table, kind of like a SELECT INTO?
asked by BK.
sybase bulk copy
I need to selectively (both rows and columns) export around 20 million rows from one table to another. This is what I tried:...--Run this in batch: INSERT INTO Table 2 Select A, B from Table1 where A > a and B < b ---Table1 have columns A, B....Z and go...
asked by lost
Page 4 of 33