SqlBulkCopy Tutorial - Knowledge Base (KB)

SqlBulkCopy fails trying to copy a row with large content in an XML column

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

XML to MS-Access 2007 using ASP.Net (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...

writing xml data to sql server using sqlbulkcopy in C# asp.net

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

SqlBulkCopy - Importing XML data into SQL table

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

Get a valid schema of large (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]....