Vision Binary

work hard, be nice, amazing things will happen


How to keep your SSIS package ‘DRY’

The Proud Salopian's avatarThe Proud Salopian

desert-1So, you all know the deal… When it comes to coding there is one rule that all half decent programmers aspire to; Nope, it’s not ‘Never toss a dwarf’ which whilst being reasonably good advice is probably not quite relevant to normal weekly challenges at the coal face of code. It is this, Keep your code DRY

And we do, we really do. We all go to huge lengths using interfaces and the like to ensure that the same operations can be leveraged against differing, but similar kinds of objects. However when it comes to using SSIS for ETL work it always seems that all of these principles go flying out of the door, at least it seems to for me. SSIS is not best suited for DRY, I have lost count of the number of times I have defined workflows like this:-

Capture

So, my challenge was to import ‘n’…

View original post 852 more words



One response to “How to keep your SSIS package ‘DRY’”

  1. Super intelligent! Plz follow 🙋
    http://messageonthebeat.wordpress.com

Leave a reply to Mike Cancel reply