Today we are releasing SQL Server Data Tools – Business Intelligence for Visual Studio 2012 (SSDT BI) templates. With SSDT BI for Visual Studio 2012 you can develop and deploy SQL Server Business intelligence projects. Projects created in Visual...

There is now a SSIS 2012 version of the "Creating a Simple ETL Package Tutorial". The tutorial and lesson packages work with the AdventureWorksDW2012 database. And, the tutorial includes a new Lesson 6 that shows you how to convert a project to the project...

In SQL Server 2012, you can use the catalog.deploy_project stored procedure to deploy an SSIS project to the SSIS server. You need to provide the binary contents of the project deployment file (.ispac extension), for the @project_stream parameter, along...

I’ve recently updated the SSIS documentation in Books Online (BOL), to add some details around setting SQL Agent job options for packages stored in the SSIS catalog, as well as in MSDB and the file system. I’ve also added some more information...

When you upgrade to SQL Server 2012 Integration Services (SSIS) on a machine that has SSIS 2005 or 2008 installed, SSIS 2012 is installed side-by-side with the earlier version. Unlike upgrades to previous versions, the upgrade process does NOT remove...

There are a whole bunch of SSIS sessions at the PASS Summit this year – I’m glad to see our product continues to be one of the most popular SQL topics around! Pre-Conference SSIS Design Patterns (BIA-299-P) - Andy Leonard , Jessica Moss , Matt Masson...

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...

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 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...

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...

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...

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...

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...

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...

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...

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...

Integration Services catalog (SSISDB) uses the encryption mechanism available in SQL Server to protect its sensitive data. So backup and restore of SSIS catalog across machines need some extra steps in addition to the usual backup and restore steps. This...

SSIS 2012 introduces significant improvements in how SSIS packages are deployed, configured and managed in a centralized SSIS catalog. The SSIS catalog corresponds to a user database, called SSISDB. You can secure the SSIS objects in the SSIS catalog...

In SQL Server 2012, SSIS includes some very useful enhancements to package variables. You can now change the scope of an existing package variable. Just select the variable in the Variables window and click the new Move Variable icon. Then, in...

An updated version of the Attunity Connectors for Oracle & Teradata are not yet available on the Microsoft.com download center, but will be up there soon. The plan is to have these connectors available in Q1 of this year. The basic functionality will...

The EzAPI project has been updated for the SQL Server 2012 release. You can find the updated source code here . Changes Task and Component IDs updated for SQL 2012 For 2005/2008 support, please use a previous version of the code Project upgraded to .NET...

Quick post – just wanted to mention the full day SSIS Design Patterns talks I’ll be doing at SQL Saturday #105 and SQL Bits X. Details are available here: SQL Saturday #105 Pre-Con SQL Bits X – Training Day For a sample...

In SQL Server 2012, you can now debug the Script component by setting breakpoints and running the package in SQL Server Data Tools ( replaces BIDS ) . When the package execution enters the Script component, the VSTA IDE reopens and displays your...

As you may already know, the SQL Native Client OLE DB provider is being deprecated. This doesn't affect other OLE DB providers or the OLE DB API. Also, the SSIS OLE DB components are not being deprecated. In SQL Server 2012 SSIS, you can continue to...

The SSIS team is now hiring developers! Would you like to be a key part of a successful team that is rapidly increasing its impact on the multi-billion dollar Data Integration market? Are you enthusiastic about data integration, transformation, performance...