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

SqlBulkCopy Tutorial - Knowledge Base (KB)

641 results

Is sqkbulkcopy a table schema replacement?

I was inserting bulk data from C# code using sqlbulkcopy.There were 15000 records in temp_upload table.Now somehow the datatable in WriteToServer() method had just one column and 37 rows....After running it I found that the table just had 37 records.Initi...
c# sqlbulkcopy
asked by Rohit Raghuvansi

How can I use an ODBC connection to conduct a SqlBulkCopy (equivalent) 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...
c# ibm-midrange odbc sqlbulkcopy sql-server
asked by Matt

SqlBulkCopy into composite primary key table

I'm trying to use SqlBulkCopy to insert new rows into my DB table by manually populating a DataTable w/in my application....This works fine for all tables ...except the table that has a composite primary key made up of 3 columns.... Whenever I try to Sql...
.net c# sql sqlbulkcopy sql-server-2005
asked by kamens

Bulk SQL Server to Oracle Copy

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...
oracle sqlbulkcopy sql-server
asked by Manav

Using sql CE and sqlbulkcopy

Is it possible to use SqlBulkcopy with Sql Compact Edition e.g. (*.sdf) files?...I know it works with SQL Server 200 Up, but wanted to check CE compatibility....If it doesnt does anyone else know the fastest way of getting a CSV type file into SQL Server ...
c# sqlbulkcopy sql-server-ce
asked by Mark H

With nullable columns, how to utilize SqlBulkCopy

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...
nullable sql sqlbulkcopy sql-server
asked by Chad

String conversion is refused by SqlBulkCopy. INT NULL is empty.

Recently I've been tasked with creating an automated ETL process that pumps the data into tables based on the flat file name by reading a master mapping file. I've decided to go with SqlBulkCopy and everything seemed to be fine. IDataReader interface was ...
ado.net c# sqlbulkcopy sql-server-2005
asked by a_person

Is it feasible to use SqlBulkCopy without the db datawriter permission in SQL 2008?

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...
security sqlbulkcopy sql-server sql-server-2008
asked by abatishchev

In SQL 2008, which right allows a user to assign himself another right?

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...
security sqlbulkcopy sql-server sql-server-2008
asked by abatishchev

Windows Service and ODBC

I'm new to windows services and... you guessed it, I’m a bit stuck. Let me paint the picture –...I’m running a timed service that use an OdbcDataReader and SqlBulkCopy to (1) archive the data (2) normalize the data on a SQL box. When I run this code...
c# odbc sqlbulkcopy windows-services
asked by DNS

Before putting into the database, convert String to bit.

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...
asp.net c# sql sqlbulkcopy sql-server
asked by vix

Insert/Update Database using SQLBulkCopy

I have a datatable with the records.I'm inserting records into Sql table using SqlBulkCopy.It works fine.Next time when get the datatable with same records with few changed values SqlBulkCopy is inserting another set of records without updating the previo...
asp.net sqlbulkcopy
asked by vix

Is it possible to utilize SqlBulkCopy without having to convert 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!
c# sqlbulkcopy sql-server
asked by Martin

When dealing with SQL Azure, SQLBulkCopy connection issues occur.

We are currently trying out the SQLBulkCopy API on the new SQL Azure CTP....While we have been able to consistently migrate tables with about a million rows, we are facing connection errors when working with larger tables. We keep getting (after random ro...
azure-sql-database sqlbulkcopy
asked by Steve

SqlBulkCopy error

i use SqlBulkCopy to insert data from OleDbDataReader (contains data from xls) to mssql-2005 i have a cloumn on the OleDbDataReader that contains number stored as text (in the xls) ...when i look into the mssql data i see null in that column all other c...
asp.net c# sqlbulkcopy sql-server-2005
asked by eyalb

Relationship between Client and Parent in SQL Bulkcopy

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...
.net sqlbulkcopy sql-server
asked by user115545

String conversion bug causes SqlBulkCopy to fail.

I have a view which generates a number of columns which I want to bulk load into another table which has identically named columns....This procedure worked fine when I was looping over the SqlDataReader and doing an insert with SqlParameters using a SqlCo...
.net sql sqlbulkcopy
asked by Tim Ebenezer

In SqlBulkCopy, get SqlDateTime overflow. WriteToServer()

I insert data from a typed dataset into my MSSQL database by using SqlBuldCopy class:...foreach (DataTable dt in ds.Tables) { using (SqlBulkCopy bulkCopy = new SqlBulkCopy(conn)) { bulkCopy.DestinationTableName = "dbo." + dt.TableName + "...
asp.net sql sqlbulkcopy
asked by Jack Black

Using the SqlHelper class with SqlBulkCopy

I've installed ...DataAccessApplicationBlock.msi... and I got the ...Microsoft.ApplicationBlocks.Data.dll... file into my bin folder. I found every other sqlhelper methods except ...ExecuteBulkCopy.......How do I add ...ExecuteBulkCopy... function to the ...
c# data-access sqlbulkcopy sqlhelper
asked by ACP

SQlBulkCopy throws a System.InvalidOperationException.

I got the following error when executing bulkcopy....System.InvalidOperationException The given value of type String from the data source cannot be converted to type decimal of the specified target column. ...I use the following code....DataTable empTabl...
c# invalidoperationexception sqlbulkcopy
asked by ACP

Page 2 of 33
  • «
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • …
  • »
  • »»

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!