February 15th, 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 [...]
Archive for the ‘Visual Studio’ Category
Integration Services EzAPI Updated to Support SQL 2012
Posted in Development, Integration Services, SQL Server 
Tags: Development, EzAPI, SQL Server, SSIS 
Comments Off101 LINQ Samples Published by Microsoft
While trying to work through various problems in LINQ that I could easily solve in T-SQL, I found a sample at code.msdn.microsoft.com (I hadn’t seen that sight before, but seems like a potential gold mine). It is called 101 LINQ Samples and at the time of this writing is the 3rd most popular download on [...]
A Better Starting Point for .Net Console Applications
Often when prototyping .Net applications, I end up starting with a console app (as things get more complicated or require interactivity, I move to Windows forms). It takes about 1 minute to get up and running with a console app. . . unless you want to start passing fancy parameters and things like that. It [...]
Using an Entity Framework Data Model in Multiple Projects
I’m starting to dig into Entity Framework 4 as part of a project that I am working on. It is great, much easier than the old school data access methods in terms of getting up and running (it takes about 3 minutes). There are a lot of articles out there, but I have still had [...]
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 OffCSVed – The World’s Best (free) CSV Editor/Viewer
If you work with data, you won’t be able to avoid delimited files for very long. Sometimes you have to open these files. If you don’t have Excel installed, you might end up having to use trusty old Notepad, which is not ideal from either a formatting or large file size perspective. Excel is better, [...]
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 [...]
Visual Studio Team System 2008 Database Edition Duplicate Menu Items
More often than not when I install Visual Studio Team System 2008 Database Edition (or “Data Dude”), I end up with duplicate menus just like the picture on the right. There is an easy fix for this, which Gert Drapers details on his Data Dude blog. The quick fix is to run these two commands: [...]
