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...
Read More
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....
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...
Read More
Failing to Preview Report in Report Builder
Abstract We recently delivered a SQL Server 2012 Reporting Services solution to a client with an additional capability for the client’s business users to be able to design, develop and publish ad hoc reports using Report Builder 3.0. During unit...
Read More
workplace with devices and documents
Compress Dynamic Files Using 7-Zip in SSIS
Abstract This blog post is in response to a request/comment from Thato in this previous article. Hence, I have taken much of the logic used in the aforementioned article and changed it from static to dynamic file compression. Thus, I am still using SQL...
Read More
Using REST API in SSIS to Extract Top 100 User Tweets
Abstract The growing popularity of the use of social networks by businesses indicate a possible change in ETL requirements. Part of this change is that developers had to revise existing ETL model such that it caters for sourcing of data off the internet...
Read More
1 3 4 5 6 7 11