Last week I posted my top 15 wish list for the next version of SSIS. Most of those were functional changes which is why they made the top 15.
Below are numbers 16 to 28. They are, in the main, aesthetic changes but are important nonetheless.
If there are any changes you'd like to see in SSIS then let me know and if I get a good number I'll put them up here in a new post.
- SQL Query Editor in Execute SQL Task to be more like a query window in SSMS. i.e. With colour coding, block indentation, no word wrapping, a "Check Syntax" button etc...
- Expression Builder attached to the Expression property of a variable
- Colour coding errors and warnings in the Output window
- Keyboard shortcuts to
-Display the variables window
-Hide all windows at runtime
-Display toolbox window
-Toggle a task being enabled/disabled
-Execute task
-Display task editor
- Auto-documentation tools
- Capture of the SQL statement that is fired on a data source within the OnInformation event
- Line number and character number indicator in the expression builder (a bit like what Textpad does)
- Ability to annotate precedence contraints. Normal annotations on the design surface won't suffice because they won't be in the right place after an Auto-Layout.
- Autocomplete on variable namespaces where the namespace has been used before (just like in Excel)
- Ability to edit the Expression & EvaluateAsExpression properties of a variable in the Variables window
- Tooltips on erroneous expressions don't stay around very long. They should stay around longer.
- Apply font formatting to annotation boxes
- Embed images in annotation boxes. This would enable us to brand packages with our company logo
-Jamie