xml

Importing XML documents using SQL Server Integration Services

Process Multi-Level XML in SSIS

Convert XML To Excel Spreadsheet xls or CSV Text File

SSIS – Read XML file in Script Component as Source

Meaning of - <?xml version=“1.0” encoding=“utf-8”?>

.....

This is the XML optional preamble.

• version="1.0" means that this is the XML standard this file conforms to
• encoding="utf-8" means that the file is encoded using the UTF-8 Unicode encoding

.....

SSIS – Read XML file in Script Component as Source

.....

SQL Server Integration Services (SSIS) Part 13 - Script Tasks using C#

by WiseOwlTutorials

.....

SSIS Tutorial Part 129-Use Variables in Script Task in SSIS Package (C# & VB NET Scripting Language)

......

Generate XML Formatted File From SQL Server - SSIS

......