SqlBulkCopy Tutorial - Knowledge Base (KB)
252 results for: in tag: sql-server
How can I perform an SqlBulkCopy (equivalent) using an ODBC connection in C#?
I am working on a project where I need to extract data from a MSSQL database table, and then insert the data into a table of the same structure on an AS400....The SqlBulkCopy would be the ideal candidate for this operation, but fails (understandably) beca...
asked by Matt
Bulk Copy from SQL Server to Oracle
I have a requirement for a project to move data from SQL Server to Oracle in bulk mode. There is OracleBulkCopy from DataDirect and ODP .net but to use that I have to first convert the data reader from SQL server into a CSV file and then can export that u...
asked by Manav
How to use SqlBulkCopy with nullable columns
I’m having an issue using SqlBulkCopy when nullable columns are involved. It sounds like SqlBulkCopy doesn't know how to deal with nullable columns and throws an illegal size error when it encounters a zero length column. The error is ..."Received an in...
asked by Chad
Is it possible to use SqlBulkCopy in SQL 2008 without permission 'db_datawriter'?
I want to limit my database possible access ways to only using stored procedures. Everything works fine except ...System.Data.SqlClient.SqlBulkCopy.... I'm using it only in one class for massive data import....Is it possible to avoid this problem?...I tri...
asked by abatishchev
Which right grants user a right to grant another right to himself in SQL 2008?
I need to grant a ...db_datawriter... before executing ...SqlBulkCopy... and remove it after:...try { "EXEC [db_mod].[sys].[sp_addrolemember] N'db_datawriter', N'my_user'" // via SqlCommand bulk.WriteToServer(table); } finally { "EXEC [db_mod].[s...
asked by abatishchev
Converting String to bit before inserting into the database
Can anyone help in converting string value in C# to bit equivalent in Sql. I'm trying to bulkcopy the values of a datatable into Sql table. All the values I've in the datatable are in string format. When I try to bulkcopy to SQL table I'm getting an er...
asked by vix
Is there a way to use SqlBulkCopy without converting the data to a DataTable?
Is there a way to use SqlBulkCopy without converting the data to a DataTable? I have a list of objects (List) in RAM and I really don't want to use more memory to create the DataTable. Could it be possible to implement IDataReader on a List?...Thanks!
asked by Martin
SQL Bulkcopy for Client / Parent relationship
we have 2 DataTables in a .NET application having a Client / Parent relationship with millions of rows. This data should be inserted into a SQL Server database via SQL BulkCopy. It is possible that multiple instances of this .NET application run in parall...
asked by user115545
Processing a flat file in chunks using multiple threads using producer/consumer pattern and SqlBulkCopy into SQL Server DB
I hope you will bear with me. I wanted to provide as much information as I can. The main problem is how to create a structure (like a stack) that will be used by multiple threads that will pop a value and use it to process one big flat file and possibly ...
asked by Rad
Rollback for bulk copy
I have an application that make a copy from my database by bulk copy class in c#....Can I rollback the bulk copy action in sql server when occur an exception?
asked by masoud ramezani
SqlBulkCopy WriteToServer example. What am I doing wrong?
This might be long, but I want to explain my example...I got this Code:...#region [parent table] DataTable dtParent = new DataTable(); DataColumn dc; dc = new DataColumn(); dc.DataType = System.Type.GetType("System.Int32"); dc.ColumnName = "Id"; dc.Uniqu...
asked by Ash
Database engine independent analog of SqlBulkCopy
What is the best database engine independent way to load a huge amount of data....While I'm using SQL Server I use SqlBulkCopy but want to untie from SQL Server
asked by abatishchev
incoherence in bcp command execution
I execute a bcp command in 2 computer. The first computer has windows xp and second one has windows server 2003. when I execute command in first, the bcp run successfully but when I run this on second one, occur this error:...Starting copy... SQLState = S...
asked by masoud ramezani
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
How to get identities of inserted data records using SQL bulk copy
I have an ADO.NET ...DataTable... with about 100,000 records. In this table there is a column ...xyID... which has no values in it, because the column is an auto-generated ...IDENTITY... in my SQL Server database....I need to retrieve the generated IDs f...
asked by Olga
How to prevent duplicate records being inserted with SqlBulkCopy when there is no primary key
I receive a daily XML file that contains thousands of records, each being a business transaction that I need to store in an internal database for use in reporting and billing. I was under the impression that each day's file contained only unique records, ...
asked by kscott
Bulkcopy inserts with DBCC CheckIdent
Our team needs to insert a cruel amount of data into our SQL Server 2008 database. We're looking for a good solution. Now we came up with one, but I have doubts with it, simply because it doesn't feel right. So I'm asking here if this seems like a good so...
asked by Dennis van der Stelt
MySqlDataAdapter or MySqlDataReader for bulk transfer?
I'm using the MySql connector for .NET to copy data from MySql servers to SQL Server 2008....Has anyone experienced better performance using one of the following, versus the other?...DataAdapter and calling Fill to a DataTable in chunks of 500...DataReade...
asked by Jeff Meatball Yang
SqlBulkCopy causes Deadlock on SQL Server 2000
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
Questions About SQl BulkCopy
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
Page 1 of 13