SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Integration Services (SSIS), XML, OPENROWSET Rss

   Items 1 to 2 of 2   
 

XML import from a Cross-tab Report

Source xml is a rendition of a cross-tab report. I show the evolution of a Spackle solution for import as a SQL resultset.  Read more...
By Wayne Findley 2017/06/08 | Source: SQLServerCentral.com | Category: xml
Rating: |  Discuss |   Briefcase | 254 reads

Basics of XML and SQL Server, Part 3: Transform and Shred XML in SSIS

This SSIS package performs multiple XSL transformations on an XML document, then shreds the transformed document and inserts its data into a SQL Server table.  Read more...
By Stan Kulp 2012/03/21 | Source: SQLServerCentral.com | Category: xml
Rating: |  Discuss |   Briefcase | 3,093 reads
   Items 1 to 2 of 2   
 
Tags
c# (1)    
dynamic sql (1)    
spackle (1)    
vb.net (1)    
xslt (1)