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 ...
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...
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...
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"/> ...
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...
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...
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...
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...
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...
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!
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...
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)) { ...
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...
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...
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...
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...
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...
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...
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...
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...
asked by fabco63
Page 8 of 33