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

SqlBulkCopy Tutorial - Knowledge Base (KB)

641 results

SaveChanges() Calls from EF Competitors

I am building a batch processing system. Batches of ...Units... come in quantities from 20-1000. Each ...Unit... is essentially a hierarchy of models (one main model and many child models). My task involves saving each model hierarchy to a database as ...
.net c# entity-framework sqlbulkcopy transactions
asked by Jeff Swensen

I'm getting an InvalidOperationException error from SqlBulkCopy because I'm adding null data, yet the table has no null values.

I have a table where one of the fields is "InDatabase" (SQL Server "bit" type) which does not allow nulls....I create a table and add a few hundred rows to it, where InDatabase is always assigned a value (InDatabase refers to whether the row is in another...
asp.net c# sqlbulkcopy
asked by user1004944

Using the WHERE clause to read an Excel file with blank rows causes an unknown error.

So clients upload Excel files to us and we have a windows service that periodically grabs new files and bulk-loads the contents to our SQL server like so:...string excelConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + filePath + ";Ex...
excel oledbcommand oledbdatareader sqlbulkcopy
asked by Alex Polkhovsky

Importing XML data into a SQL database using sqlBulkCopy

I'm having proplems with importing an XML file using ...SqlBulkCopy.... The XML file looks like this:... <root> <Automobiles> <Car Id="1" Name="SomeModel1"/> <Car Id="2" Name="SomeModel2"/> <Car Id="3" Name="SomeModel2"/> ...
.net dataset sqlbulkcopy xml xmldocument
asked by ilkin

When using SqlBulkCopy to insert into a sql variant column, how do I specify the column type?

I'm using SqlBulkCopy to insert/update from a .net DataTable object to a SQL Server table that includes a sql_variant column. However SqlBulkCopy insists on storing DateTime values put into that column as sql type 'datetime' when what I need is 'datetime...
ado.net datatable sqlbulkcopy sql-server sql-variant
asked by BowserKingKoopa

How do I retrieve the main keys of rows entered using a bulk copy from in PostgreSQL?

The goal is this: I have a set of values to go into table ...A..., and a set of values to go into table ...B.... The values going into ...B... reference values in ...A... (via a foreign key), so after inserting the ...A... values I need to know how to ref...
bulk performance postgresql sql sqlbulkcopy
asked by Claudiu

How to adjust postgresql+python for copy from?

What function can I use to adapt values for suitable use in a ...COPY FROM... statement? I tried this ...adapt... function:...from psycopg2.extensions import adapt ...However, it gives the wrong thing for datetimes (appends ...::timestsamp... to the strin...
database postgresql python sql sqlbulkcopy
asked by Claudiu

Dates (1/1/1753) and SQLBulkCopy

I've got an application which has been working fine for quite a while, but there is an annoying item that continues to get in the way on occasion. ...Let's say that I use an object such as OracleDataReader or MySQLDataReader to pass the data to the sqlbul...
ado.net datetime sqlbulkcopy sql-server
asked by mdjtlj

Copy certain text data type values to exponential values using ASP.Net SqlBulk.

ASP.Net SqlBulkCopy some text data type values converting to exponential values ...bulkCopy.DestinationTableName = "TABLE NAME"; bulkCopy.ColumnMappings.Add("Mobilenumber", "Mobilenumber"); bulkCopy.WriteToServer(dr); ...above code inserting excel column...
asp.net sqlbulkcopy
asked by Ganesha

Is it true that SQL SqlBulkCopy does not remove leading spaces from columns?

So Im using SqlBulkCopy to insert records into my database, but when doing so it is removing any leading spaces in my column. Is there a way for it not to do so? Please help!
sql sqlbulkcopy
asked by Brandy Salisbury

For long transactions, should I use (fluent) NHibernate progress events?

We've hooked up the ISaveOrUpdateEventListener event and hoped we could tie it to a progress bar update for each node being visited during the save traversal of a pretty big model, BUT the event only fires once when the save operations starts (only on the...
event-listener fluent-nhibernate progress-indicator sqlbulkcopy
asked by Mosca Pt

SQL bulk insert delete not functioning in transaction

I need to delete some records from table and then insert some records to the same table. This delete and insert process should be in transaction....Below is what i did.... using (SqlConnection sqlConn = new SqlConnection(connectionString)) { ...
ado.net c# sqlbulkcopy sql-server-2008 transactions
asked by Muthukumar

In iis6, sqlbulkcopy with ASP works, but not in iis7.

I am able to get sqlbulkcopy working well on iis6(testing server) and iis7(live server) but when uploading the data in iis7, the rows are cut off. It only imports ~190,000 out of 250000 in iis7. In iis 6 using the same code/page it loads all 250000 record...
iis-6 iis-7 records sqlbulkcopy
asked by sunkur

Unblockable SqlBulkCopy many tables in ASP.NET MVC

I have to make a multiple copy of tables from one database to other with SqlBulkcopy from an ASP.NET MVC application....The process takes more than 2 minutes, and I do not trust users....Wich is the best way to do the entire process, even if the user clos...
asp.net-mvc multithreading sqlbulkcopy
asked by cdiazal

SqlBulkInsert is used in production applications.

We are currently developing an application that generates upwards of 5-10,000 rows of data in a particular table for each user session. Currently we are using sql text commands to insert each row of data at a time so a save operation could take up to a mi...
bulkinsert c# database sql sqlbulkcopy
asked by PCG

SQL Bulk Copy to SQL Server with Data Modifications in Excel

I am reading up on ...SQLBulkCopy... and would like to use it to import thousands of rows from an Excel document to SQL Server. I keep reading articles that do it directly without modifying the data. I need to do some modifications and validations on the...
excel sqlbulkcopy sql-server
asked by Mike Flynn

Is there a BulkUpdate command in SQL Server 2008 that is equivalent to BulkCopy?

I have used ...BulkCopy... command to transfer rows from one table to another table with bulk data about 3 to 5 million rows. I want to update these rows....Is there any ...BulkUpdate... command similar to the ...BulkCopy... command? I'm using ASP.NET wit...
c# sqlbulkcopy sql-server sql-update
asked by SHEKHAR SHETE

Table access is denied by SqlBulkCopy.

After reading in an excel-sheet (to transferTable), I want to add that data to a new table (destinationTable) using SqlBulkCopy, but I'm getting the error:...Cannot access destination table 'test' ...I've tried using the default tablename and using square...
c# database sqlbulkcopy sql-server
asked by SND

How to Use BulkCopy Without Having to Create a Destination Table

All, ...I have the following ...BulkCopy... operation:...// Convert the FlexGrid to a DataTable. DataTable currData = (DataTable)c1ErrFlexGrid.DataSource; // Insert the data into the database. SqlBulkCopy SqlBulkIns = new SqlBulkCopy(strConnString, SqlBu...
c# datatable sql sqlbulkcopy
asked by MoonKnight

To export a matrix in SQL, use SqlBulkCopy and F#.

I want to transfer a large amount of data from F# to an SQL table. Basically my F# code creates a matrix of three columns (...UserID, ProductID and price...) and N lines. I would like to "copy/pate it" into a database I tried several options but at the en...
f# matrix sql sqlbulkcopy
asked by fabco63

Page 8 of 33
  • ««
  • «
  • …
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • …
  • »
  • »»

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!