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

SqlBulkCopy Tutorial - Knowledge Base (KB)

17 results in tag: sql-server-2005

How do I configure Fire Triggers and Check Constraints in SqlBulkInsert?

I'm performing a bulk insert with an ADO.NET 2.0 SqlBulkCopy object from a C# method into a MS SQL 2005 database, using a database user with limited permissions. When I try to run the operation, I get the error message:...Bulk copy failed. User does not ...
ado.net sqlbulkcopy sql-server-2005
asked by James Orr

When does SqlBulkCopy check for constraints?

If SqlBulkCopyOptions.CheckConstraints option is set for SqlBulkCopy insert, does it check the constraints separately after each record, or after all records are inserted?...I have a check constraint that compares some columns to the parent row (through a...
constraints sqlbulkcopy sql-server-2005
asked by Riikka Heikniemi

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

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

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

Improving the performance of thousands of Insert queries in SQL Server 2005. 120ms logout-login time

Can somebody shed some lights on how SQL Server 2005 deals with may request issued by a client using ADO.NET 2.0. Below is the shortend output of SQL Trace. I can see that connection pooling is working (I believe there is only one connection being pooled)...
bulkinsert flat-file import sqlbulkcopy sql-server-2005
asked by Rad

I'm having trouble using sqlbulkcopy.

I have created a datatable and trying to insert that datatable through SqlBulkCopy but somehow it doesn't seem to work for me.... ...I got the error,...The given value of type DateTime from the data source cannot be converted to type decimal of the specif...
c# sqlbulkcopy sql-server-2005
asked by ACP

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...
c# sqlbulkcopy sql-server sql-server-2005
asked by chobo2

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...
c# sql sqlbulkcopy sql-server-2005
asked by chobo2

Using sp dboption, you can't allow select into/bulkcopy on a SQL Server 2005 database.

I am trying to enable the select into/bulkcopy database option on a SQL Server 2005 database using the command:...EXEC sp_dboption 'mydbname', 'select into/bulkcopy', 'true' ...After executing the above, running ...EXEC sp_dboption 'mydbname', 'select int...
database-permissions sqlbulkcopy sql-server sql-server-2005
asked by Jason Sparks

SQL Server 2005 allows you to bulk copy data from a small table to a bigger table.

I'm a newbie in SQL Server and have the following dilemma:...I have two tables with the same structure. Call it ...runningTbl... and ...finalTbl.......runningTbl... contains about 600 000 to 1 million rows every 15 minutes....After doing some data cleanup...
bcp sqlbulkcopy sql-server sql-server-2005
asked by Ernesto

How can I read a huge file from disk into a database without running out of space?

I feel embarrassed to ask this question as I feel like I should already know. However, given I don't....I want to know how to read large files from disk to a database without getting an OutOfMemory exception. Specifically, I need to load CSV (or really ta...
csv file-processing out-of-memory sqlbulkcopy sql-server-2005
asked by Mr Moose

Why Doesn't My SqlBulkCopy Work?

I am using SqlBulkCopy object to write a datatable into an sql server table. However, everytime I recheck my database it remains intact with no changes. A...I have tried to do Google search to determine my problem but i am unable to resolve it....The data...
asp.net c# sqlbulkcopy sql-server-2005
asked by rofans91

How to Update a SQL Server Table Using Data from a Different Source (DataTable)

I have a ...DataTable... which is generated from .xls table....I would like to store this ...DataTable... into an existing table in SQL Server database....I use ...SqlBulkCopy... to store rows which have ...unique PK.......Problem is, I also have other ro...
asp.net c# datatable sqlbulkcopy sql-server-2005
asked by rofans91

On the local computer, the 'Microsoft.ACE.OLEDB.12.0' provider is not registered.

i have followed the answer to this thread ...C# import excel filesheet to sql database error... and am able to import excel data into an SQL Server Database. The only problem am having is that the Import works only when am running the website locally from...
asp.net oledb sqlbulkcopy sql-server-2005
asked by StackTrace

In SQL Server 2005, how can I bulk transfer comparable data to two tables?

I've 'inherited' some code that I am having a hard time working with. The application has an excel import function to import members to a members table, and ...SqlBulkCopy... is used. ...A few months ago a junction table was added and two of the attribute...
sql sqlbulkcopy sql-server-2005
asked by Iris Classon

.Net datetime with milliseconds sql server using bulkcopy thows exception

I have this code, which throws exception....SqlConnection con; con = new SqlConnection(connectionStr); SqlCommand cmd = con.CreateCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = @"select [ID], [VERSION_ID], '08/26/2015 09...
.net c# sql sqlbulkcopy sql-server-2005
asked by digitally_inspired

Page 1 of 1
  • 1

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!