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

SqlBulkCopy Tutorial - Knowledge Base (KB)

11 results in tag: xml

Attempting to duplicate a row with significant content in an XML column using SqlBulkCopy fails.

I am trying to copy a record from one SQL Server table to another. Both tables have the same structure, one of the columns is of type xml. Source table has a large xml content in of the rows, about 2.5Mb....I saved the content of the xml column into a fi...
sql sqlbulkcopy sql-server xml
asked by stask

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 heav...
asp.net sqlbulkcopy vb.net xml
asked by Mehboob

Using sqlbulkcopy in C# asp.net to write xml data to a SQL server

I have two xml files on m system called customers.xml and customerdetails.xml. I am attempting to write this data directly to an sql database I created in asp.net. All of my coding is in C#. The sql database contains a table called CustomerDetails which h...
c# sqlbulkcopy sql-server xml
asked by Rose

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

Obtain a suitable schema for 1 GB xml files.

I need to bulk load huge xml files to SQL Server 2005. I decided to use SQLXMLBULKLOAD in my C# app, but I need to get valid xsd-schemas of those xml files to load them. Which is best way to generate xsd file? I tried MS VS xsd.exe, but it tries to load t...
sql sqlbulkcopy sqlxml xml xsd
asked by Andrey Gordeev

Pattern matching on xsd:element name

I am using SQL XML bulk load to inject the data direct to the database. My XML and xsd are as the following:...XML:...<?xml version="1.0"?> <Data> <USEFUL> <Value>3.1</Value> <Date>12/20/2001</Date> </USEFUL> <Something> <V...
regex sqlbulkcopy xml xml-parsing xsd
asked by user8181818

Import a lot of xml files

What is the best approach to import multiple xml files which are in very big number (ex: 30000) with different schema to Sql Server 2008?...I am currently looping through each file, loading data to ...datatable... and using ...SqlBulkCopy... to insert the...
c# sqlbulkcopy sql-server-2008 xml
asked by gee'K'iran

SqlBulkCopy XML with a GUID foreign key

I am tryin to insert data using XML files and SqlBulkCopy. The destination table is a time series table set up as below...create table TimeSeries ( Id uniqueidentifier constraint DF_TimeSeries_Id default (newid()) not null, ObjectId un...
c# guid sqlbulkcopy uniqueidentifier xml
asked by Rio

Insert xml data into SQL server via SqlBulkCopy with powershell (casting error)

I'm getting a "cast not valid" error when trying to insert a data table containing xml using sqlbulckcopy....I cast the DataColumn that will hold the xml data to type System.Xml.XmlNode is that incorrect? Looking ...here... it just says the .NET Framework...
.net powershell sqlbulkcopy sql-server xml
asked by red888

Allow reading of multiple XMLfile names from folder using SQL code

I have a created a stored procedure that functions fine with a hard coded XML file name. However I cannot keep hard coding the file name as every time a new file comes in it will have a different file name although the XML structure remains the same....I ...
openrowset sql sqlbulkcopy tsql xml
asked by Zonke

Error with SqlBulkCopy: invalid character but the XML string seems to be valid

I am having an issue with SqlBulkCopy (in c#, framework 4.5.1) where a valid XML string is causing the error System.Data.SqlClient.SqlException: {"XML parsing: line 1, character 29, A string literal was expected"}"...The table is... ...CREATE TABLE [dbo]....
c# escaping sql sqlbulkcopy xml
asked by Sam Jazz

Page 1 of 1
  • 1

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!