Data flow source

Using The Data Mining Query Task in SSIS

The Data Mining Query Task can be used to run prediction queries based on data mining models built in analysis service.

Master Data Services - SSIS MDM Load

The article will provide an overview of Master Data Services and a sample SSIS Package.

Dynamically Map Column Data Based on Column Pattern Profiling

Tutorial on using Script Component, Regular Expression and derived Column Transform to dynamically map different source column types into the appropriate target column for address data.

Use SSIS to import one cell of an Excel file into SQL Server

Recently I needed to find a method to import one cell of an Excel sheet into SQL Server 2005 using a scheduled job on a 64 bit clustered environment. For example, I have a monthly sales report listing sales per product category, such as Books, Magazines, DVDs, etc. I only want to import the Total Sales amount into SQL Server and this number is located in an Excel file "sales.xls.sheet1.cell.B5". I used to use OPENROWSET to solve the problem, however OPENROWSET requires Microsoft Jet OLE DB Provider which is not available in 64 bit. In this tip I am going to talk about how to use SSIS to accomplish this task easily.

Using Analysis Services Processing Task & Analysis Services Execute DDL Task in SSIS

Learn how the Analysis Services Processing Task can be used to process analysis services objects such as cubes, dimensions and mining models.

Professional Microsoft SQL Server 2008 Integration Services - Sample Chapter

Get a feel for this book from

We Loaded 1TB in 30 Minutes with SSIS, and So Can You

In February 2008, Microsoft announced a record-breaking data load using Microsoft® SQL Server® Integration Services (SSIS): 1 TB of data in less than 30 minutes. That data load, using SQL Server Integration Services, was 30% faster than the previous best time using a commercial ETL tool. This paper outlines what it took: the software, hardware, and configuration used. We will describe what we did to achieve that result, and offer suggestions for how to relate these techniques to typical scenarios. Even for customers who don't have needs quite like this benchmark, such efforts can teach a lot about getting optimal performance.

Using WMI Data Reader and WMI Event Watcher Tasks in SSIS

Windows Management Instrumentation (WMI) Tasks within SSIS can be used by to read WMI data and to watch for WMI events.

Scripting in SSIS – Part 1

Learning to script is a valuable skill for a DBA. Learning to script is invaluable for an SSIS developer and MVP Andy Warren starts a new series that examines the basics of adding scripts to your packages.