p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/)
-   BOOK: Professional SQL Server 2005 Integration Services ISBN: 0-7645-8435-9 (http://p2p.wrox.com/book-professional-sql-server-2005-integration-services-isbn-0-7645-8435-9-242/)
-   -   SSIS XML as a destination? (http://p2p.wrox.com/book-professional-sql-server-2005-integration-services-isbn-0-7645-8435-9/43321-ssis-xml-destination.html)

GethWho June 1st, 2006 03:50 AM

SSIS XML as a destination?
 
Hi all,

Just started using SSIS a week ago, and was surprised to note that I couldn't find XML as a destination for a Data Flow activity. Having just picked up my copy of Professional SQL Server 2005 Integration Services yesteday, I thought I'd find out where I went wrong, but so far, no joy.

Is there a default XML destination for SSIS?

If not, does anyone know of an XSLT document/sample out there that purely does a copy of an XML file? (I should note that I've only started looking at XML data, and XSLT specifically, 2 days ago, when the requirements came through.) It might sound a bit silly, but I found some XSLT code that strips out namespaces - if I apply that as the Operation Type on my XML Task, and choose my output as a text file (create file) connection, then it appears to spit out valid XML into the final file.

I realize that I could just use the File System Task to simply copy a file. My task, however, is to take 2 or more XML file's (none of them described by XSD's since they are dynamically created and will have varying structure's), merge those, then merge a csv file, and final generate an XML file per a specific DTD. Not too bad a task for the first thing I need to do in SSIS or XML, ever.[xx(]

Needless to say - any help/direction/sample would be HUGELY appreciated.:D

Thanks all.....


bchi49 November 4th, 2006 02:51 PM

I just started this too. Here is an article about it:
http://blogs.conchango.com/jamiethom...7/11/4209.aspx

Benjamin Chi

Xantari June 15th, 2008 10:08 PM

You can get an XML destination adapter for SSIS along with several other SSIS components at http://www.keelio.com


sushantrao September 21st, 2010 03:51 PM

Generating the XSD
 
Quote:

Originally Posted by GethWho (Post 43321)
Hi all,

Just started using SSIS a week ago, and was surprised to note that I couldn't find XML as a destination for a Data Flow activity. Having just picked up my copy of Professional SQL Server 2005 Integration Services yesteday, I thought I'd find out where I went wrong, but so far, no joy.

Is there a default XML destination for SSIS?

If not, does anyone know of an XSLT document/sample out there that purely does a copy of an XML file? (I should note that I've only started looking at XML data, and XSLT specifically, 2 days ago, when the requirements came through.) It might sound a bit silly, but I found some XSLT code that strips out namespaces - if I apply that as the Operation Type on my XML Task, and choose my output as a text file (create file) connection, then it appears to spit out valid XML into the final file.

I realize that I could just use the File System Task to simply copy a file. My task, however, is to take 2 or more XML file's (none of them described by XSD's since they are dynamically created and will have varying structure's), merge those, then merge a csv file, and final generate an XML file per a specific DTD. Not too bad a task for the first thing I need to do in SSIS or XML, ever.[xx(]

Needless to say - any help/direction/sample would be HUGELY appreciated.:D

Thanks all.....


Is it possible for you to share the code that eliminates the namespaces? Actually, I've been trying to generate an XSD by using the source XML file; however it threw an error saying "Unable to infer the XML file. There are too many namespaces."

Sushant Rao

sqldaddy January 14th, 2016 06:52 AM

SSIS XML Source
 
have got this thread and Here I would like to answer according to this. I have a package of SSIS XML Source , Where all the things is discussed in well proper way. There are various feature of this package that will helpful to do.
1.Read XML data from any SOAP/REST API Web Service using methods such as GET/POST.
2.Read XML data from single or multiple XML files (use of wildcard allowed. e.g. c:\data\*.xml)
3.Support for Path expression to extract data from any level (e.g. Extract Orders nested under Customer Node).
4.Support for passing custom headers to SOAP or REST Web service
5.Support for looping through multiple files using wildcard pattern (e.g. *.xml).
6.REST API Paging support to loop through multiple requests (see)
7.Support for SQL Server 2005, 2008, 2012, 2014 (32 bit and 64 bit)

We have also discussed some tutorials . Kindly Have a look
http://zappysys.com/products/ssis-po...is-xml-source/

Hope It will be helpful.

sqldaddy February 3rd, 2016 07:22 AM

SSIS doesn’t have Xml destination
 
Quote:

Originally Posted by GethWho (Post 43321)
Hi all,

Just started using SSIS a week ago, and was surprised to note that I couldn't find XML as a destination for a Data Flow activity. Having just picked up my copy of Professional SQL Server 2005 Integration Services yesteday, I thought I'd find out where I went wrong, but so far, no joy.

Is there a default XML destination for SSIS?

If not, does anyone know of an XSLT document/sample out there that purely does a copy of an XML file? (I should note that I've only started looking at XML data, and XSLT specifically, 2 days ago, when the requirements came through.) It might sound a bit silly, but I found some XSLT code that strips out namespaces - if I apply that as the Operation Type on my XML Task, and choose my output as a text file (create file) connection, then it appears to spit out valid XML into the final file.

I realize that I could just use the File System Task to simply copy a file. My task, however, is to take 2 or more XML file's (none of them described by XSD's since they are dynamically created and will have varying structure's), merge those, then merge a csv file, and final generate an XML file per a specific DTD. Not too bad a task for the first thing I need to do in SSIS or XML, ever.[xx(]

Needless to say - any help/direction/sample would be HUGELY appreciated.:D

Thanks all.....

Hello Geth,
SSIS doesn't have XML destination , I have researched this even and I have got the following way,
1.1. By writing dot net script
1. Drag the script component on the Data Flow task.
2. Write the script in VB.Net language in the preferred xml format. This script is package specific we need to write the script according to the requirements. Kindly go through the embedded document.
3. Through the third party components
Some third party components are available in the market.
4.Download XML SSIS Toolkit SQL 2005 – 2.1. They have given the installation manual as well. Go through the pdf in order to install the component.
5. Through the developed custom (Xml destination) component. Following is the procedure to use the custom component .
start here
Thanx


All times are GMT -4. The time now is 07:12 PM.

Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.