April 5th, 2012 
I have used both the Teradata and Oracle connectors in the past. While there are some “gotcha’s” (for example you must have SQL Enterprise), overall they provide the fastest possible way to extract data from either of those two sources. v2.0 brings support for SQL 2012 and the latest releases of Teradata and Oracle, as [...]
Archive for the ‘Integration Services’ Category
Integration Services EzAPI Updated to Support SQL 2012
Just got word from Matt Masson on the SSIS development team that EzAPI has been updated to support SQL 2012. This is greate news! I have been using EzAPI for the last couple of months and I am very satisfied with it as an API for SSIS that allows me to focus on solving the [...]
Posted in Development, Integration Services, SQL Server 
Tags: Development, EzAPI, SQL Server, SSIS 
Comments OffEditing Existing SSIS Package via EzAPI or Standard SSIS API Doesn’t Update Layout in BIDS
As part of a project I am working on that requires me to programmatically alter existing packages, I ran into an annoyance (bug?) in SSIS that makes it hard to open packages after altering them. The Problem During an exchange on Codeplex forums with Matt Masson from the SSIS team, he summarized the workflow as [...]
Posted in Development, Integration Services, SQL Server Tags: .NET, BIDS, C#, EzAPI, SSIS Comments OffDeveloping Microsoft SSIS packages programmatically with EZAPI
I recently started working on a task that required me to dig into creating SQL Server Integration Services packages programmatically. There is not a lot of info out there on this, so thought it might be beneficial for me to blog a bit as I go in case other benefit from this. Relatively early on [...]
Posted in Development, Integration Services, SQL Server Tags: Development, EzAPI, SQL Server, SSIS Comments Off