Showing posts with the label XML

Data modeling in Power BI using XML file with Parent and Children nodes

[2017-Aug-08]  Support for XML structured files as a data source has been available in Excel, then …

Calculating Travel Distance/Time in Power BI using Bing Map API

[2017-July-24] Map visualization in Power BI has drawn many data professionals into a field of сrea…

SSIS Appetizer: XML source is already sorted

Case I have a large XML file with Orders and Onderlines which I want to (merge) join into a new des…

Custom SSIS Component: XML Validation Task

Case A while ago I did a post on validating XML files in SSIS with nested XSD files. The out of th…

XSD location hardcoded in XML source

Case The path of the XSD file in the XML Source component is hardcoded, but the path on my producti…

Validating XML file against XSD with SSIS - part II Script Task

Case I have an XML file which I want to validate against an XSD file before processing it. However …

Validating XML file against XSD with SSIS - part I

Case I have an XML file which I want to validate before processing it. How can I validate an XML fi…

Foreach folder enumerator

Case I want a Foreach Folder Enumerator, but the Foreach Loop component only loops through files. S…

Downloading all packages from your SQL Server

Case A few month ago I had a job to add some adjustments to a SSIS project, but they lost the Visua…

Load More That is All