XML

Export to XML Using SSIS

  • Article

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.

2013-06-27

3,831 reads

Ad-Hoc XML File Querying

  • Article

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?

2013-03-28

3,174 reads

Manipulating XML Data in SQL Server

  • Article

When the average database developer is obliged to manipulate XML, either shredding it into relational format, or creating it from SQL, it is often done 'at arms length'. A shame, since effective use of techniques that go beyond the basics can save much code,

2012-11-01

3,886 reads

Blogs

Azure Database for PostgreSQL

By

Having worked with Azure SQL Database and its many flavours for couple of years...

Why I Support Code Automation Tools Like ORMs

By

I know I’m a weirdo. I’ve always been a weirdo. When I was a...

#PowershellBasics: Run a file and pass it a parameter.

By

I realized in my last #PowershellBasics post that I was talking about running a...

Read the latest Blogs

Forums

Error on executing rename statement

By VSSGeorge

Error on executing rename statement in a table. Not able to debug this. Please...

In-memory database

By LLSQL42

Hi, Currently i am processing records in SQL Server itself. Any recommended in-memory database,...

Replication CDC -- Cannot Truncate Table

By GonnaCatchIT

Dear All, We just enabled Replication services (CDC) on few of the databases. Now...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers