Or lack of 
My current project requires SSIS (SQL Server 2008 Integration Services) packages for ETL processing.
SSIS seems very capable, but lacks fundamental things that a developer like me takes for granted. I did not expect SSIS to have the ability of inheritance as it isn’t object-oriented, but I did expect functions or methods like a procedural language or set-based languages like T-SQL. Sadly the answer is no.
You can make script tasks or script component with custom T-SQL or .Net code, but logic in expressions you have to duplicate.
I goggled reuse and SSIS and found this statement in an article about reuse in SSIS at SqlServerCentral.com:
Let’s not forget, copy&paste is the first level of code reuse
In essence it’s true, but I would hope the entire Information Technology industry has move way beyond this point years ago.
This post at the Microsoft SQL Server forum confirms this horrific truth about lack of reuse in SSIS
Anders Lybecker is an chief architect at Kring Development A/S, a consultancy firm in Copenhagen, Denmark.
He holds a degree in software engineering specializing in software development.
His primary expertises are the Microsoft .Net framework and SQL Server which he has been working with since the start of this century!
He enjoys discussing technical topics, teaching and speaking at conferences. Related posts:
- Levels of reuse in Software Development
- SQL Server build version
- Computer game ilities
- SQL Server Open World
- Easy win – index candidates on SQL Server 2005
Tags: SQL Server, SSIS