Latest Blog Post – Importing XML in SSIS
Using SSIS to Import HTTP-Based XML Document http://www.blogs.selectsifiso.com/?p=1009
May 2015
Using SSIS to Import HTTP-Based XML Document
Introduction The post, XML Document Sourced SSRS Report Using HTTP URL, demonstrated how a SQL Server Reporting Services (SSRS) data source can be used to reference an Extensible Markup Language (XML) document located via Hypertext Transfer Protocol (HTTP) protocol-based URL. Another approach to reporting off an XML document is to first extract the XML data using SQL Server Integration …
XML Document Sourced SSRS Report Using HTTP URL
Introduction In my Business Intelligence development experience, most of my SQL Server Reporting Services (SSRS) Reports have largely been based on relational data sources such as Microsoft SQL Server and Oracle database. However, in some instances whereby an SSRS report is based on an Operational Data Source (ODS) or Online transaction processing (OLTP) system, Extensible Markup …
Introducing the New-Look select SIFISO Blog
Welcome to the New-Look select SIFISO Blogs Welcome to the new and revitalized weblog of select SIFISO Blogs. The focus of the new-look blog is to create and maintain an ever-present online presence – as far as technical blog writing is concerned. We also hope to expand the number of blog authors on the site …
Presenting at Upcoming (12/05/2015) Johannesburg SQL User Group Meeting
Join me at the Johannesburg SQL Server Group Meeting where I will be presenting the first session on integration of SQL Server Data Quality Services with Master Data Management and SQL Server Integration. Attend Event The rest of the agenda is as follows: Agenda Welcome and announcements SQL Server 101 (Level 200 …
Presenting at Upcoming (12/05/2015) Johannesburg SQL User Group Meeting Read More »