Home Dashboard Directory Help
Search

SSIS: Reusable Data Flow Components by BlueRaja


Status: 

Closed
 as Won't Fix Help for as Won't Fix


9
0
Sign in
to vote
Type: Suggestion
ID: 586075
Opened: 8/13/2010 7:14:52 AM
Access Restriction: Public
0
Workaround(s)
view

Description

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.
Details
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: https://connect.microsoft.com/SQLServer/feedback/details/338609/ssis-package-parts
Sign in to post a workaround.