Select Sifiso

Month: 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 …

Using SSIS to Import HTTP-Based XML Document Read More »

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 off a relational data sources such Microsoft SQL Server and Oracle database. However, in some instances whereby an SSRS report is based off Operational Data Source (ODS) or Online transaction processing (OLTP) system, Extensible Markup Language …

XML Document Sourced SSRS Report Using HTTP URL Read More »

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 »