Month: March 2019

First published on MSDN on Sep 19, 2012

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… Continue reading SSIS Sessions at the 2012 PASS Summit→

First published on MSDN on Sep 19, 2012

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 al… Continue reading SSIS with AlwaysOn→

First published on MSDN on Jul 17, 2012

Microsoft SQL Server 2012 Master Data Services (MDS) enables you to build and manage master data for your operational or analytical needs. But how do you export that master data from MDS into… Continue reading Exporting Master Data White Paper Published→

First published on MSDN on Jul 10, 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… Continue reading Video about CDC for Oracle Databases in SSIS 2012→

First published on MSDN on Jul 03, 2012

The Cumulative Update 2 (CU2) release for SQL Server 2012 is out, and it fixes a DQS issue where the DQS_PROJECTS database use to grow excessively during the knowledge discovery or the cleans… Continue reading Excessive database growth issue fixed in DQS in the CU2 Release for SQL Server 2012→

First published on MSDN on Jun 25, 2012

The SQL Server 2012 Cumulative Update 1 (CU1) release enables support for DQS as part of a clustered SQL Server 2012 setup.

Ensure that you install the CU1 release as mention… Continue reading DQS supported in a SQL Server 2012 cluster→

First published on MSDN on Jun 20, 2012

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-… Continue reading Balanced Data Distributor (BDD) for SQL Server 2012 is Now Available→

First published on MSDN on May 04, 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 2… Continue reading Migrating SQL Server 2000 Data Transformation Services (DTS) Packages to SQL Server 2012→