SSIS Wish List

I am offering my wish list in the hopes that some or all of this functionality may eventually become part of SSIS.
Hope this contribution is useful for all including the MS SSIS Product Team.


Fix the inability to correctly copy and paste packages [when pasted all the following should be assigned new IDs]:


Connection Managers

Variables

Control Flow Tasks

Event Handlers

Data Flow Components (Sources, Transformations, Destinations)

Enhance Annotations


Allow Rich-Text Formatting

Allow linking to a Task/Component

Allow fields based on expressions to be inserted to form dynamic annotations (e.g. like MS Word)

ALLOW copy and paste like all other SSIS objects

Add Event Handlers to Data Flow Components


Extend a version of the task host concept down to the data flow components

Correctly populate the ExecutionInstanceGUID system variable to align with SSIS logging (fix 2005)

Create new (very useful) system variables (most like the concept of Me in VB.NET or This in C#)


Current Control Flow Task Name

Current Control Flow Task ID

Current Control Flow Task Description

Package Description

Current Data Flow Component Name

Current Data Flow Component ID

Current Data Flow Component Description

Current Event Handler Creation Name

Current Event Handler Name

Current Event Handler ID

Current Event Handler Description

Current Event Handler Executable

Fix the inability to correctly copy and paste Event Handlers containing a Data Flow Task


Paste works but Data Flow Task Components are invisible and non-editable

Recopying the DFT Components creates them with 1's appended (thus orig. copied are there)

Current W/O is to delete the DFT from newly copied Event Handler and recopy from Source

Add EvaluateAsExpression Property Values to Variables Pane (Helps knowing source of variable valuation)

Change GUI to disable and color (bolded grey) a Property and its value when they are being valued using an Expression

Change GUI to alter color and bolding of a Property and its value when they are being valued from a Package Configuration

Create new Package Level Event Handlers


OnPackageStart (fired just prior to first Control Flow Task's OnPreExecute Event Handler)

OnPackageEnd (fired just after to last Control Flow Task's OnPostExecute Event Handler)