SQLXML Bulk Load connection string

bulk-load c# sqlbulkcopy sql-server sqlxml

Question

I use SQLXML Bulk Load to import data from xml to DB. With MS Sql Server 2008 works great.

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 create MS SQL Compact CE 3.5 database - tempDb.sdf and try to connect to this DB 

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

But have - Invalid connection string. How to fix this?

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

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

At first in connection string using data source and Microsoft.SQLSERVER.CE.OLEDB.4.0, so connection string work - 

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

But then i see this message (on execute method) -

Bulkload will only work with SQL Server 2000 or later.

So I think that SQLXML 4.0 not supported ms sql compact ce

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

Related Questions

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

I am download a XML file comprising thousands of records. I want that XML file to convert it to MS-Access 2007 Database using ASP.Net (VB) and run further queries on it. Its worth mentioning that the conversion should be done in bulk because its very heavy file and take longer to insert one by one record. I am tired of googling code to fulfill my r...
asp.net sqlbulkcopy vb.net xml
asked by Mehboob

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

I want to insert many rows (constructed from Entity Framework objects) to SQL Server. The problem is, some of string properties have length exceeded length of column in database, which causes an exception, and then all of rows will unable to insert into database. ...So I wonder that if there is a way to tell SqlBulkCopy to automatically truncate an...
.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 server-generated. There are several levels of relations, so after each batch is inserted the correct identity keys need to be retrieved to use as the foreign key values in the next batch....What is the simplest way to d...
entity identity-column orm sqlbulkcopy sql-server
asked by jnm2

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

The code below is what I use for inserting the data stored in txt file to sql:... 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

The problem I am having is that in the Web.Config, I have a connection string which db.database is using, this works fine, I am able to retrieve data from the database no problem, however the problem I am having is when I try to use SqlBulkCopy:...using (SqlBulkCopy bulk = new SqlBulkCopy(db.Database.Connection.ConnectionString)) { bulk.Destina...
c# database-connection entity-framework sql sqlbulkcopy
asked by user2836518

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

I'm fairly new to Entity Framework. I've come across a scenario where I have my 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 { get; set; } ...
bulkinsert c# entity-framework sqlbulkcopy
asked by Max

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

So I have a database of site location information which contains 27 columns. I have coded a bulk import feature that takes a CSV file and lets you modify information. Everything works well when the CSV file contains information in every column, but when there is an empty string/null it will push an empty string to the database and wipe out what was...
.net c# csv mysql sqlbulkcopy
asked by ouro

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

I have created Ole DB connection to execute different SQL task across SSIS package. Its working fine too....In one of task where i need to do insert data into table, used SQLBulkCopy as i have dynamic tables and columns based on getting files from different sources....SQLBulkCopy only works with SqlConnection, so i opened SqlConnection, executed Sq...
oledbconnection sqlbulkcopy sqlconnection ssis
asked by Manish Joisar

My Sql Bulk inserts loading the data with truncating

I am trying to load the data from CSV file to MYSql database through bulk insert option. Here are the below create table syntax and CSV file ...CREATE TABLE discounts ( id INT NOT NULL , title VARCHAR(10) NOT NULL, expired_date DATE NOT NULL, amount VARCHAR(255 ) NOT NULL ); ...CSV file format:..."475","Back","20140401","FFFF" "476...
bulkinsert mysql sqlbulkcopy truncation
asked by Karthick Sambanghi

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

I'm using ...EFCore BulkExtensions... 2.5.0 with Entity Framework Core 2.2.3 and EFCore.SQLite 2.2.6....I have code like this:...// Repo that throws exception on BulkInsert public class UserRepository { private readonly IDbContextProvider<ReportContext> _dbContextProvider; public async Sync(IList<User> users) { await _dbContextPr...
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