SSIS Package Configurations are very useful to make packages flexible so that you can change objects properties at run-time and thus make the package configurable without having to open and edit it.
In a complex scenario where you have dozen of packages (even in in the smallest BI project I worked on I had 50 packages), each package may have its ...

Today I've relased the latest version of my DTExec replacement tool, DTLoggedExec.
The main changes are the following:
Used a new strategy for version numbers. Now it will follow the following pattern Major.Minor.TargetSQLServerVersion.Revision
Added support for Auto Configurations
Fixed a bug that reported incorrect number of errors ...

PASS Summit 2010 Pre & Post conference are out! This year I’ll deliver the “Creating BI Solution from A to Z” seminar in which, as the title implies, attendees will see how to create a BI solution starting from scratch. Going through the dimensional modeling and the creation of the Datawarehouse, the implementation of the ETL process with ...

Thanks to my friend's Doug blog I’ve found a very nice tool made by fellow MVP Darren Green which really helps to make SSIS develoepers life easier:
http://expressioneditor.codeplex.com/Wikipage?ProjectName=expressioneditor
In brief the tool allow the testing of SSIS Expression so that one can evaluate and test them before using in SSIS ...

When you install SQL 2008 R2 workstation components you get a newer version of BIDS (BI Developer Studio, included in the workstation components) that replaces BIDS 2008 version (BIDS 2005 still live side-by-side). Everything would be good if you can use the newer version to edit any 2008 AND 2008R2 project.
SSIS editor doesn't offer a way to set ...

After serveral years of development I’ve finally released the first non-beta version of DTLoggedExec! I’m now very confident that the product is stable and solid and has all the feature that are important to have (at least for me).
DTLoggedExec 1.0
http://dtloggedexec.codeplex.com/releases/view/44689
Here’s the release notes: FIRST ...

Finally today I found the time to publish the latest release of my DTLoggedExec tool. This is quite big release, since I have introduced two new events, LogStartPackageLoading and LogEndPackageLoading, that allows a Log Provider to intercept event related to package loading and not package execution. This is really helpful to debug those situation ...

After showing DTLoggedExec at SQL PASS I had quite a lot (good) of feedback, and so I decided to pospone the release I was ready to deploy to the public, to introduce new features and the default reporting capabilities I also showed during my session.
I worked hard and finally the new 0.2.3.0 version is ready! Some bug fixed, added new events to ...

Tomorrow morning I’ll fly to Seattle for the usual PASS Community Summit. I’m really happy for the next week. Even if this period is really full of work and a week away means that at my return I’ll have *really* busy times, the PASS Conference is always a nice break: meeting old and new friends, learning new things, enjoying beers and cocktails ...

While I was working on a package to incrementally load a dimension in the DWH I’m developing for a customer, I stumbled upon a tricky little bug (I think, I still have to have a response from MS) that had – and will have – a little impact on how I create my packages.
I’ve found that, when working on an empty table that has an identity column, if ...