SQL Server Integration Services (SSIS)

SQL Server Integration Services (SSIS) resources for developers and IT professionals.

Getting Started

About SQL Server Analysis Services (SSAS) Multidimensional Data

What is SQL Server Integration Services (SSIS)?

White Paper: SSIS Overview | What's New | Product Overview

Learn SQL Server Analysis Services (SSAS) Multidimensional Data

Learn SSIS

New to SSIS? Start Here | Tutorials | Getting Assistance

Troubleshoot SQL Server Analysis Services (SSAS) Multidimensional Data

Troubleshoot SSIS

Knowledge Base | Forums | Support | Error Messages | EventID.Net

SQL Server 2012 Help

Looking for help content, installation, and other resources on:
SQL Server 2012

SQL Server Integration Services Featured "How Do I" Video

Part 3: Installing PowerPivot for SharePoint on a Domain Controller

Highlights

Integration Services (SSIS) - SQL Server

Importing Data from 64-bit Excel in SSIS
Learn about methods for importing data from 64 bit Excel, including using the SQL Server Import and Export Wizard. Blog post by Hrvoje Piasevoli.

Error Output
Download this custom transformation that converts cryptic SSIS error output information into understandable information.

Designing a Robust and Resusable ETL Prototype using SSIS
Learn about designing a ETL prototype that addresses the challenges of insufficient load testing and inability to reuse packages. Blog post by Siddharth Mehta, Associate Manager with Accenture Services Pvt Ltd and Microsoft MVP.

Automating SSIS
Watch this video to learn how to generate SSIS packages and programmatically read and change properties of existing packages. Video by Andre Kamman, SQL Server consultant and Microsoft MVP.