SQLXML Bulk Loader Basics

SQLXML isn't exactly new technology, but like the even more venerable BCP, it remains the quickest and most reliable way of heaving large quantities of data into SQL Server databases. SQLXML is very versatile, and once set up is wonderfully reliable ETL system, but isn't trivial to learn. Adam Aspin comes to the rescue with a simple guide.

Archiving Hierarchical, Deleted Transaction Using XML

When you delete a business transaction from the database, there are times when you might want to keep a record of the data for posterity. In this article, Dwain Camps looks at a tidy means of doing just that.

Which query will give an error?

XML Workshop : Utilizing Relational Data In XML Files

Have you received an XML file that must be migrated into a production database? Today’s workshop dives into an ad hoc method of processing relational datasets delivered in an XML file format.

XML Schema validation in SQL Server

An introduction to the XML Schema Collection and XML validation.

value() Method (xml Data Type)

Parse XML to table

A stored procedure that will parse (shred) the contents of any well-formed XML document into a SQL table.

Export to XML Using SSIS

Exporting data to XML format using SSIS initially seems like it should be straight forward – just dump it in a flat file and give it a name xml type, however SSIS has no XML destination just an XML source. I had no luck dumping the XML in flat file. My solution was to use a script task which worked well.

Ad-Hoc XML File Querying

When you need to shred just part of the data within a large XML file into a SQL Server table, the most efficient way is to just select what you need via XQuery or by using XPath, before shredding it into a table. But precisely how would you do that?

Convert XML to String with formatting

Converts xml value into multi line string with indents