SQLXML Bulk Load connection string

bulk-load c# sqlbulkcopy sql-server sqlxml

Question

I import data from xml to the database using SQLXML Bulk Load. MS SQL Server 2008 performs well.

SQLXMLBULKLOADLib.SQLXMLBulkLoad4 objBL = new SQLXMLBULKLOADLib.SQLXMLBulkLoad4();
            objBL.ConnectionString = "Provider=sqloledb;server=server;database=databaseName;integrated security=SSPI";
            objBL.ErrorLogFile = "error.xml";
            objBL.KeepIdentity = false;
            objBL.Execute ("schema.xml","data.xml");

Then I construct a database using MS SQL Compact CE 3.5.tempDb.sdf and attempt to access this DB

objBL.ConnectionString = "Provider=Microsoft.SQLSERVER.CE.OLEDB.3.5; database = D:\\project\\xmlread\\xmlread\\bin\\Debug\\tempDb.sdf;integrated security=SSPI";

Invalid connection string, though. How can we solve this?

1
0
3/18/2015 11:01:52 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

using a connection string initiallydata source and Microsoft.SQLSERVER.CE.OLEDB.4.0 connection string is functional, therefore

objBL.ConnectionString = "Provider=Microsoft.SQLSERVER.CE.OLEDB.4.0; 
data source = D:\\project\\xmlread\\xmlread\\bin\\Debug\\tempDb.sdf;";

I then see the following message (on the execute method):

Bulkload will only work with SQL Server 2000 or later.

Therefore, I believe that MS SQL Compact CE does not support SQLXML 4.0.

0
3/27/2015 8:26:56 AM

Related Questions

ASP.Net to MS-Access 2007 conversion (Bulk Insert, Bulk Copy)

A large XML file with hundreds of records is what I'm downloading. I want to use ASP.Net (VB) to convert the XML file into an MS-Access 2007 database so that I can do more queries on it. It's important to note that conversions should be carried out in bulk since the files are large and time-consuming to input one record at a time. I'm sick of searc...
asp.net sqlbulkcopy vb.net xml
asked by Mehboob

When doing bulk inserts, how can you automatically truncate strings?

I want to insert a lot of records into SQL Server that were built using Entity Framework objects. The issue is that certain string attributes have lengths that exceed the length of database columns, leading to exceptions that prevent the database from accepting any further entries for insertion....I thus wonder if it is possible to instruct SqlBulk...
.net c# sqlbulkcopy sql-server
asked by Quan Mai

What is best practice for updating server generated entity IDs after a bulk insert?

There are just under a million nodes in an object graph, mostly disconnected, that need to be imported in bulk....The keys are all created by the server. Since there are several layers of relations, it is necessary to extract the appropriate identity keys after each batch is inserted so that they may be used as the foreign key values in the next ba...
entity identity-column orm sqlbulkcopy sql-server
asked by jnm2

Using the SQL bulk copy in C# and deleting the string headers

I use the following code to insert data from a text file into a SQL database:... public void extract_data() { openFileDialog1.ShowDialog(); DataTable dt = new DataTable(); StreamReader sr = new StreamReader(openFileDialog1.FileName); string input; dt.Columns.Add(new DataColumn("Counter", typeof(string)));...
c# datetime sql sqlbulkcopy sql-server
asked by Lucas Juan

Connection string works for Entity framework but fails on bulk

ZZZ_tmp
c# database-connection entity-framework sql sqlbulkcopy
asked by user2836518

Entity Framework selectively save tracked entities from context and bulk insert others

I've just started using Entity Framework. I came into a situation where I had the following entities:...public class Company{ public int Id { get; set; } public string Name { get; set; } public IList<Project> Projects{ get; set; } } public class Project { public int Id { get; set; } public List<ProjectRecord> ProjectRecords { g...
bulkinsert c# entity-framework sqlbulkcopy
asked by Max

C# - Importing a CSV where empty strings do not get sent through bulk import to database

I thus have a database with site location data with 27 columns. I have coded a bulk import feature that takes a CSV file and lets you modify information. When every column in the CSV file is filled with data, everything runs well; however, if any of the columns are empty or null, the database will be overwritten with an empty string....My customer ...
.net c# csv mysql sqlbulkcopy
asked by ouro

SSIS - OleDB connection not updating data, inserted thru SQLBulkCopy with SQL Connection

I set up an Ole DB connection to run several SQL tasks across an SSIS package. It also runs well....I utilized SQLBulkCopy for a job where I needed to put data into a database since my tables and columns are dynamic and depending on files I acquire from various sources....Because SQLConnection is required for SQLBulkCopy to function, I opened SqlCo...
oledbconnection sqlbulkcopy sqlconnection ssis
asked by Manish Joisar

My Sql Bulk inserts loading the data with truncating

I'm attempting to bulk insert data from a CSV file into a MySQL database. The table-creation syntax and CSV file are provided below....CREATE TABLE discounts ( id INT NOT NULL , title VARCHAR(10) NOT NULL, expired_date DATE NOT NULL, amount VARCHAR(255 ) NOT NULL ); ...CSV file type:..."475","Back","20140401","FFFF" "476","bbbbbbbb...
bulkinsert mysql sqlbulkcopy truncation
asked by Karthick Sambanghi

EFCore Bulk Insert & SQLite In Memory: no such table: INFORMATION_SCHEMA.COLUMNS"

I'm using ...BulkExtensions for EFCore... 2.5.0 together with EFCore.SQLite 2.2.6 and Entity Framework Core 2.2.3....I have the following code:...// Repo that throws exception on BulkInsert public class UserRepository { private readonly IDbContextProvider<ReportContext> _dbContextProvider; public async Sync(IList<User> users) { a...
c# entity-framework-core in-memory-database sqlbulkcopy sqlite
asked by Philip Pittle

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow