SSIS: Reusable Data Flow Components - by BlueRaja

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 586075 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 8/13/2010 7:14:52 AM
Access Restriction Public


The most fundamental principle of every engineering practice is Don't Repeat Yourself.  This is so ubiquitous that every field has a different name for it:

- DRY/DIE (Engineering)
- Code Reuse (Software design)
- Single Source of Truth (Database development)
- Occam's Razor (Everywhere!)

Yet, there is no way to design reusable components in SSIS.  This is the absolute deal-breaker to any software designer who has considered learning SSIS for a project.  To us, copying and pasting between every data flow is simply not an option.
Sign in to post a comment.
Posted by Kerry Jiang on 10/25/2013 at 2:30 AM
I also has this feeling.

The data flow task cannot be reused within the package by passing different data source...
It would be great if every task, every control flow can be invoked like functions.
Posted by Jamie Thomson on 8/13/2010 at 8:41 AM
Totally totally agree. Been asking for this for years: