Pages

Friday, September 19, 2008

SSIS SCD Component on CodePlex

My second blog post was all about blowing my own horn for developing a custom SSIS component to "properly" handle slowly changing dimensions as an alternative to the stock SSIS SCD wizard. Read that to catch up on why I thought it was necessary. Back then, I said that I might publicize the component - and today I did just that. Why? Three years into SSIS's life, and a month or so after the release of SQL 2008, I can't find any other alternatives. SQL 2008's SCD Wizard is no different from SQL 2005's - so says Microsoft - so I thought I might get some limelight by offering mine up. And isn't that what the internet and open source is all about?
Exactly. So this post is also all about blowing my own horn. Except now you can call bullsh*t if it's unwarranted! Go look over the project on CodePlex, download the binaries and play with it. My documentation is as good as Microsoft's ;p. (As in non-existent at the moment.)
I'm all new to using CodePlex, so if there's something I'm not doing right, just shout and I'll see what I can do.
Even if you're not interested in an SCD component, but you are trying to code your own custom SSIS component, you might want to download the source. As I said earlier, Alberto Ferrari's TableDifference component source helped me a lot, and this might help you.

2 comments:

  1. This looks fantastic! I've never been happy with the SCD wizard, so can't wait to try this out. Thanks for making it open source!

    ReplyDelete
  2. You're welcome! If you have any difficulties or suggestions, please post them up on CodePlex.

    ReplyDelete