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 ‘SQL Server’ Category
Complete SQL 2012 Demo Build Script
There is no need to download the 28GB BI Image X (which at the time of this writing hasn’t been updated to SQL 2012 RTM). There are instructions on how to build an all-up SQL 2012 and SharePoint 2010 demo VM with instructions for configuring all of the latest SQL 2012 tools including DQS, MDM, [...]
Microsoft BI Image X: SQL 2012 RC0 Available for Download
Periodically Microsoft refreshes their BI Demo virtual image that contains a fully configured instance of their latest BI tools with demo data. Last week they made the latest version available for download. They are calling it BI Image X and it contains SQL 2012 RC0 and it is available here. This one contains the new [...]
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 OffIndex of all SQL Server build numbers since 7.0 Beta
Stumbled across a nice SQL Server build number site a while back that has a comprehensive (I think?) list of every SQL Server build from the SQL 7 beta 3 up through SQL 2012 RC1 including every CU and hotfix along the way. There is also a link to download the KB that corresponds to [...]
Editing 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 OffStrange SSIS Error for Configurations on Configuration Table Data Type Change from NVARCHAR to VARCHAR
Recently I got a strange SSIS error. The error was for each of the package configurations I had in place that pulled their values from the SSIS Config table. The ones that used the .dtsConfig file or environment variables were not throwing errors. Here is the exact error: Warning: The package path referenced an object [...]
Version 1.1 of Microsoft SSIS Connectors for Teradata and Oracle by Attunity Released
I just noticed that Microsoft release version 1.1 of the Attunity connectors for both Teradata and Oracle at the end of Q1 2010. There are some decent improvements and they can be downloaded at this link. I have used the Attunity Oracle connector in a limited capacity in the past, but plan to be using [...]
