Abstract This article explains how to Programmatically download SQL Server Integration Services (SSIS) packages from an instance of SQL Server 2008...
Download & Save SSIS Packages from SQL Server 2008 Instance to XML Format
read more
Programmatically Import Delimited Text File with Derived Columns into Flat File Destination Using SSIS’s Script Task Tool
Abstract This article is in response to a request that was sent by one of my blog's subscribers regarding scripting an SSIS package with derived...
Latest Blog Post – Importing XML in SSIS
Using SSIS to Import HTTP-Based XML Document http://www.blogs.selectsifiso.com/?p=1009
Load Integration Services Assembly File Into Visual Studio 2010 Project
Abstract SQL Server Integration Services 2012 comes with a new API for scripting packages which is called MOM - Managed Object Model. This API is...
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...
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...