The "XML Destination" is used to export XML data within an SSIS package.
XML Destination is included in all releases for backwards compatibility, but has been discontinued for future development. It is recommended that users, instead, choose the XML Generator Transform or the XML Output Destination.
• 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.
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
■ 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.
• 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.
o Don't Write Empty File? - Selecting this option will not write anything when there is no output from the source.
• Formatting Settings
o Encoding - The encoding of the outputted XML file.
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.