SqlBulkCopy Tutorial - Knowledge Base (KB)

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...

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...

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...

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"/> ...

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...

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...

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...

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...

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...

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 ...

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]....