Import XML Files into SQL Server 2005 or 2008

Presented is a script that allows one to import all XML files in a specific directory into SQL Server 2005 or 2008 and store it as XML. Most of what is presented should work for importing the contents of any type of file, not just XML. The example uses OLE Automation Procedures to extract extra data that one may find of use storing along with the XML such as file creation time, size, etc. Continue reading “Import XML Files into SQL Server 2005 or 2008”

New Blog

It has been some time since I posted anything to this blog.  Since moving from Billings to Salt Lake City, I haven’t had the time to get my old WordPress server up and running.  In that light I decided to try Blogger on Google.

I have quite a few of my older posts that need to be converted and eventually they will.  I know many of you found them helpful.  It will be interesting to see how the conversion process from WordPress to Blogger turns out.  So be patient and check back often.

Thank you for your support!