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 ...
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...
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...
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 ...
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...
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)...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
asked by digitally_inspired
Page 1 of 1