SSIS with AlwaysOn

In SQL Server 2012, AlwaysOn Availability Groups maximizes the availability of a set of user databases for an enterprise. In addition, SSIS introduces new capabilities which allow customers with the ability to easily deploy to a centralized SSIS Catalog (i.e. SSISDB user database). In this article, we explore how you can make use of SSIS…


Video about CDC for Oracle Databases in SSIS 2012

This video presentation Rakesh Parida (MSFT) demonstrates how to perform CDC for Oracle databases using SSIS 2012. You’ll learn how the CDC features work, how to create and administer the CDC service, as well as how to use logs and traces to troubleshoot the service. The video is availble online at http://technet.microsoft.com/en-us/sqlserver/jj218898.aspx . For more information…

2

Balanced Data Distributor (BDD) for SQL Server 2012 is Now Available

The Balanced Data Distributor (BDD) transform has updated and released for SQL Server 2012. The BDD transform makes it easy to split your data flow up on a buffer-by-buffer basis. The two primary scenarios for it are when you want to do parallel inserts into a destination… … and when you want to parallel work…


Migrating SQL Server 2000 Data Transformation Services (DTS) Packages to SQL Server 2012

SQL Server Integration Services (SSIS) 2012 doesn’t support migrating or running DTS packages.  You do have the following options for migrating your DTS packages to SSIS 2012. Migrate the packages to SSIS 2005 or SSIS 2008, and then upgrade the packages to SSIS 2012. For information about migrating packages to 2005 or 2008, see Migrating Data Transformation Services Packages (2005)…

8

What Topics Would You Like to See at SQL PASS 2012?

Hello everyone! The PASS Summit Call for Speakers is open until May 13th, and we’re looking for ideas. What SSIS topics would you like to see presented by the SSIS team this year? Here are some ideas that we’ve been tossing around…. SSIS performance Using SSIS with Azure/SQL Azure CDC in 2012 Upcoming improvements Advanced…


SSIS Presentations from SQL Bits Available Online

Three slide decks from the SSIS presentations I did at SQL Bits X in London have been posted online. These include: SSIS Performance Design Patterns – full day training session! What’s New in SSIS for SQL Server 2012 – breakdown of the new features and functionality in SQL Server 2012 SSIS Catalog – Overview of…


Microsoft Connectors v2.0 for Oracle and Teradata – Now Available

The new Attunity connectors for Oracle and Teradata are now available on Microsoft.com. This version (v2.0) supports SQL Server 2012, and adds some new functionality for SQL Server 2008 / 2008 R2 (v1.2). From the site: Microsoft Connector Version 2.0 for Oracle by Attunity – The Oracle source and destination components are written to achieve…


SSIS Case Study – Innovapost

An interesting case study about how SSIS is used by Canada Post has recently been published. The article mentions how they built an SSIS scale-out solution which processes 10-15 GB of data per day (with four worker nodes). Definitely an interesting read! If you’d like to know more about building your own scale-out solutions with…


Bulk Loading Data to Oracle

In SQL Server 2005, and the non-Enterprise editions of SQL 2008/SQL 2008 R2, SSIS doesn’t provide an out-of-the-box option for bulk loading Oracle data. Instead, SSIS components implement single row inserts to load data to Oracle.  This can result in issues such as long load times and timeout during the ETL process. This article on MSDN provides…

1

CDC for Oracle in SQL Server 2012

One of the new features introduced in SQL Server 2012 is the ability to use SQL Server CDC for tracking changes on an Oracle table. In the following post you will understand how to setup such a service for tracking changes on your Oracle tables. Configuring your Oracle server Before creating the service, you must…