Tag Archives: Data Flow Task

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

Programmatically Insert Conditional Split Transformation in Data Flow Task of SSIS Package Using C#

Abstract This article explains how to create an SSIS package with both Data Flow Task and Conditional Split Transformation connected together using C# programming language. Requirements Microsoft Visual Studio 2008 (or later editions) SQL Server 2005 (or later editions) AdventureWorks2008R2 database (downloadable database file available here) Article If the above requirements are all met, we… Read More »

Programmatically Create Data Flow Task with Row Count Transformation in SSIS Package Using C#

Abstract This article explains how to programmatically create data flow task with row count transformation in SQL Server Integration Services Package Using C#. Requirements Microsoft Visual Studio 2008 SQL Server 2008 AdventureWorks2008R2 database (downloadable database file available here) Article If the above requirements are all met, we will begin by launching Microsoft Visual Studio 2008.… Read More »