Task Factory - Urban Outfitters
"We have found that Task Factory tremendously speeds up the development process and improves performance by means of the high-performance components."

Tim Harris

BI Data Engineer

Urban Outfitters Inc.

Task Factory Loews Corporation
"We bought the product mostly because of the company's reputation for the service they provide and the specific need of a secure SFTP task."

Matt Cushing

Application Systems Analyst/Developer

Loews Corporation

Greater New York City Area

Task Factory - Mark Marinovic
"We bought Task Factory primarily for the SCD Type 2 task, as it enabled us to do several things the built-in SSIS SCD task did not do. Task Factory comes highly recommended from me as our ROI was reached in just days."

Mark Marinovic

Task Factory
"I have found Task Factory to be a huge time saver with SSIS development. The SalesForce components alone saved close to two months of work on a major integration project. I highly recommend!"
Alan Rubel
Database Administrator
Joint Commission Resources
Task Factory - Jay Cole
"I purchase Task Factory over a year ago, and let me tell you, IT WORKS FLAWLESSLY. I haven’t had a single problem with it, and I used to HATE having to make changes with the version you’re using. My advice (for what it’s worth) is to pay the money!"

Jay Cole



Buy Now Free Trial Download Compare Editions

Task Factory XML Destination

The XML Destination allows the user to export source data to an XML File

Feature Highlights

  • The name of the column can be customized to output any name needed instead of the column name from the source.
  • Column data can be exported as an attribute, element, element with CDATA or element with XML Data
  • Null data can be handled by exporting an empty xml element / attribute, ignoring the attribute / element or replacing the null data with a custom value.
  • The order in which the column data is exported can be fully customized.
  • A preview of the file that will be exported can be viewed for correctness in the user interface

Formatting options:

  • Encoding options are UTF-8, UTF-16, UTF-32 or Ascii
  • The XML header can be included or left out of the XML file
  • Data can be exported on one single line or formatted with a newline after each row, indenting each row and element, adding a newline after each attribute
SSIS XML Destination Adapter Task

SSIS XML Destination Adapter- Step 1

The Xml Destination is used to export xml data within an ssis package.

The Xml Destination is used to export xml data within an ssis package.

SSIS XML Destination Adapter- Step 2

General Tab

The general tab gives the user many options to control how the outputted xml file will be formatted

General Tab

The general tab gives the user many options to control how the outputted xml file will be formatted

SSIS XML Destination Adapter- Step 3

Output File Settings

This section controls where the xml file will be outputted to.

 Output File Connection  The name of the file connection manager where the file will be outputted to. Can either be a flat file or file connection type.
 Output Path Stored In Variable  Check this option to tell the Xml Destination that the path of the outputted xml file will be contained in the variable selected in "Output File Path Variable"
 Output File Path Variable  The name of the variable that contains the path where the xml file will be outputted to

 

Output File Settings

This section controls where the xml file will be outputted to.

 Output File Connection  The name of the file connection manager where the file will be outputted to. Can either be a flat file or file connection type.
 Output Path Stored In Variable  Check this option to tell the Xml Destination that the path of the outputted xml file will be contained in the variable selected in "Output File Path Variable"
 Output File Path Variable  The name of the variable that contains the path where the xml file will be outputted to

 

SSIS XML Destination Adapter- Step 4

Mappings

 Include  Check the box in this column if the data from the respective source column will be included in the outputted xml file
 Input Column  Read Only column that display which source column the row is for
 Xml Name  The name of the element or attribute that will be outputted to the xml file
 Style  
  • Attribute (e.g. ContactID= ”1”)
  • Element - <ContactID>1</Contact>
  • Element with cdata - <ContactID><![CData[1]]></ContactID>
  • Element with xml data – This option allows the user to output raw xml instead of the xml being escaped (e.g. < turned into &lt;)
  •  Null Handling  Give the user three options on how to handle null source data

  • Output empty attribute / element – Outputs empty element or attribute (e.g. <ContactID /> or ContactID= ””)
  • Don’t output attribute / element – The xml data is ignored and not outputed
  • Replace null data with user defined value – Replaces null data with a user defined value. For instance if the MiddleName source column was null, they could replace it with “None” and the output would be <MiddleName>None</MiddleName>
  •  Order  The order in which the data will be outputted to the xml file

    Mappings

     Include  Check the box in this column if the data from the respective source column will be included in the outputted xml file
     Input Column  Read Only column that display which source column the row is for
     Xml Name  The name of the element or attribute that will be outputted to the xml file
     Style  
  • Attribute (e.g. ContactID= ”1”)
  • Element - <ContactID>1</Contact>
  • Element with cdata - <ContactID><![CData[1]]></ContactID>
  • Element with xml data – This option allows the user to output raw xml instead of the xml being escaped (e.g. < turned into &lt;)
  •  Null Handling  Give the user three options on how to handle null source data

  • Output empty attribute / element – Outputs empty element or attribute (e.g. <ContactID /> or ContactID= ””)
  • Don’t output attribute / element – The xml data is ignored and not outputed
  • Replace null data with user defined value – Replaces null data with a user defined value. For instance if the MiddleName source column was null, they could replace it with “None” and the output would be <MiddleName>None</MiddleName>
  •  Order  The order in which the data will be outputted to the xml file

    SSIS XML Destination Adapter- Step 5

    The advanced tab gives the user more options to control how the outputted xml file will be formatted.

    The advanced tab gives the user more options to control how the outputted xml file will be formatted.

    SSIS XML Destination Adapter- Step 6

    XmlDocument Settings

    The xml document settings specifies root element and namespaces as well as determines where the data should be checked for invalid characters

     Root Document Element Name  The name of the root xml element.
     Root Document Element Namespace  The name of the root xml element namespace
     Row Document Element Name  The name of the row xml element
     Row Document Element Namespace  The name of the row xml element namespace
     Remove invalid characters  Selecting this option will remove invalid characters from the source data before exporting it to xml

    http://www.w3.org/TR/2000/REC-xml-20001006#charsets

    XmlDocument Settings

    The xml document settings specifies root element and namespaces as well as determines where the data should be checked for invalid characters

     Root Document Element Name  The name of the root xml element.
     Root Document Element Namespace  The name of the root xml element namespace
     Row Document Element Name  The name of the row xml element
     Row Document Element Namespace  The name of the row xml element namespace
     Remove invalid characters  Selecting this option will remove invalid characters from the source data before exporting it to xml

    http://www.w3.org/TR/2000/REC-xml-20001006#charsets

    SSIS XML Destination Adapter- Step 7

    Formatting Settings

    This section allows the user to choose the look and encoding of the outputted xml file

     Encoding  The encoding of the outputted xml file. Options are UTF-8 (Default), Unicode, UTF-32, Ascii
     Indent Elements  This option indents and adds a newline to each element of a row of data
     Add newline after each attribute  (Only available with indent elements). This option adds a newline to each attribute of a row of data
     Add newline after each row  (Only available if indent elements is not selected). This option adds a newline after each row of data
     Output XML Header  Determines whether or not the xml header will be outputted with the xml file

    Formatting Settings

    This section allows the user to choose the look and encoding of the outputted xml file

     Encoding  The encoding of the outputted xml file. Options are UTF-8 (Default), Unicode, UTF-32, Ascii
     Indent Elements  This option indents and adds a newline to each element of a row of data
     Add newline after each attribute  (Only available with indent elements). This option adds a newline to each attribute of a row of data
     Add newline after each row  (Only available if indent elements is not selected). This option adds a newline after each row of data
     Output XML Header  Determines whether or not the xml header will be outputted with the xml file

    SSIS XML Destination Adapter- Step 8

    The Preview tab will preview the data that will be outputted in the xml file.


    The Preview tab will preview the data that will be outputted in the xml file.


    View Our Suite of Pragmatic Works Products
    Copyright 2014 by Pragmatic Works