XML

Parent Previous Next


XML Destination


The "XML Destination" is used to export XML data within an SSIS package.



  Output File Settings

o   Output File Connection - The name of the file connection manager where the file will be outputted to. You can use either a flat file or file connection type.

o   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"

o   Output File Path Variable - The name of the variable that contains the path where the XML file will be outputted to.

 Mappings

o   Include - Check the box in this column if the data from the respective source column will be included in the outputted XML file.

o   Input Column - Read only column that displays which source column the row is for.

o   XML Name - The name of the element or attribute that will be outputted to the XML file

o   Style

  Attribute

  Element

  Element with cdata

  Element with XML data

o   Null Handling - Define how to handle null source data

  Output empty attribute / element - Outputs empty element or attribute

  Don't Output attribute / element - the XML data is ignored and not outputted

  Replace null data with user defined value - Replaces null data with a user defined value.

o  Order - The order in which the data will be outputted to the XML file.


Advanced


  XMLDocument Settings

o  Root Document Element Name - The name of the root XML element

o  Root Document Element Namespace - The name of the root XML element namespace

o  Row Element Name - The name of the row XML element

o  Row Document Element Namespace - The name of the row XML element namespace

o  Remove Invalid Characters? - Selecting this option will remove invalid characters from the source data before exporting it to XML.

 Formatting Settings

o   Encoding - The encoding of the outputted XML file.

  UTF-8

  Unicode

  UTF-32

  ASCII

o  Indent Elements? - This option indents and adds a newline to each element of a row of data

o  Add newline after each attribute - (Only available with indent elements) This option adds a newline to each attribute of a row of data.

o  Add newline after each row - (Only available if indent elements is not selected) This option adds a newline after each row of data

o  Output XML Header - Determines whether or not the XML header will be outputted with the XML file.


Preview Output - This tab will preview the data that will be outputted in the XML file.