HTTP Connection

Using SSIS to Import HTTP-Based XML Document

1 Comment / Data Flow Task, HTTP Connection, XML / By

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

Leave a Comment / HTTP Connection, SSRS, XML / By

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 …

XML Document Sourced SSRS Report Using HTTP URL Read More »

Using REST API in SSIS to Extract Top 100 User Tweets

4 Comments / API, Data Flow Task, HTTP Connection, OLEDB Connection, Script Component / By

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 in addition to the traditional flat files or OLE/ODBC Connections. In this …

Using REST API in SSIS to Extract Top 100 User Tweets Read More »