Create an XML Destination for an SSIS Package
You can create an XML destination component by using the Script Component, and by using the SSIS public APIs. This curated view includes links to articles on how to create a generic custom script component and how to create a custom script component that is an XML destination. In addition, there is a link for downloading a custom XML destination component that is created using the SSIS APIs.
02 Sep 2013
Creating a Destination with the Script Component
The Script component and the infrastructure code that it generates for you simplify significantly the process of developing a custom data flow component. This article describes how to configure the component metadata and how to write the custom script.
BI Thoughts and Theories » Blog Archive » XML Destination Script Component
This blog post shows you how to implement your own XML destination by using the Script component. Code examples are included
Microsoft SQL Server Integration Services: Flexible XML Destination
This blog post shows you how to create a flexible XML destination. Both C# and VB.NET code examples are provided.
Microsoft SQL Server Community Samples: Integration Services - Download: XML Destination
This sample illustrates the creation of a moderately complex, custom XML destination in C#, using the public APIs for Microsoft SQL Server Integration Services. The sample download includes source and binary for the Data Flow component. You can use this sample to learn more about how to: 1)Create custom data flow destination components for use with SSIS; 2)Build component user interfaces; and 3)Support multiple inputs on a single component.