My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/SSIS Feature wish list
The new RSS feed is here
Kirk recently asked for feedback on what would be good in future versions of SSIS
Here is my current list.
- Advanced Editor support for >1 input. (This should enable the script component with > 1 input)
- Read only access to the whole package from componentmetadata, not just that related to the component.
- Parallel For each loops. Performance.
- Option on Raw file to create once per package. This allows the same raw destination to be used in a loop
- Debug support for script component (not just the task)
- Parallel multicast. Says it all really performance (I know the memory issue but it should be an option. Allows for the creation of a new execution tree. It would be great if the compiler (process that produces execution tree) could figure this out. This would probably need to now the distribution of data being processed.
- Suggest Types for flat files to provide the option of reading a whole file. This is to avoid encountering bugs during run time, which is very time consuming.
- Suggest types for flat files to all for data to be just strings, rather than convert data to proper types. This is for performance
- IIS Log file connection both source and destination would be good. But would settle for source.
- Multiple data readers out of package. This would enable a package to produce multiple summaries and have them consumed by a report or other application.
- Be able to drag a connection from one component to another. Its a real pain to delete one connection to be recreate it to the other component. This looses any data viewers
- UNDO, the ability to undo actions. many currently can't be undone.
For list of all users request go to the forum post http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=92699&strela=1&to_pid=0x00037FFE:0x80DF10EC¬ification_id=212223&message_id=212223&agent=messenger
... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SSIS Feature wish list