SqlBulkCopy Tutorial - Knowledge Base (KB)
17 results for: in tag: sql-server-2005
SqlBulkInsert - How to set Fire Triggers, Check Constraints?
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
At which stage does SqlBulkCopy check 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 table with composite primary key
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
SqlBulkCopy refuses to convert String.Empty into INT NULL
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 problem
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
SQL Server 2005: Improving performance for thousands or Insert requests. logout-login time= 120ms
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
Sqlbulkcopy doesn't seem to work for me
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
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
Possible to get PrimayKey IDs back 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
Cannot enable select into/bulkcopy on SQL Server 2005 database using sp_dboption
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
Bulk Copy from small table to larger one in SQL Server 2005
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 do I read a large file from disk to database without running out of memory
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 My SqlBulkCopy Is Not Working
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 SQL Server Table With Data From Other 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
The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine
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
How to bulk copy similar data to two tables in SQL Server 2005?
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