SSIS 11 CTP1 still runs on Visual Studio 2008
An easy and quick zoom on the flow
A special toolbox for SSIS
Grouping by functionality (like before) and by favorites, common
Information on each component and a small help icon which will be online and specific for that component with videos and How To for that component.
A new data source (and destination) wizard to assist you in building the data source more easily.
Each task takes its own Meta Data. We’re no longer dependant in one component by the ones that came before it. We don’t need to reconfigure it if we deleted something before it.
In case of a problem in the Meta Data, we can use mapped columns, whether with auto match or by choosing on our own.
An ability to group components to helps you understand more easily the package visually. (Does not affect the way the components run).
Undo support and redo support
In SSIS 11 CTP1 we have a project as a container for a few packages which we can move parameters between them. We can now have better and easier administration of our packages.
Parameters getting their value from outside and then become unchangeable inside the running of the package. Server name is a string batch number is int32. We no longer necessarily need a configuration file which we should change from the environment of the development to that of the production.
Variables can change during run time. Parameters cannot. A variable can take the value in the parameter (server name) and we can use it in the variable to add something to it (a certain folder in that server). That way we can use the data in a parameter in an expression.
We can define a parameter in the scope of the whole project and not just for the specific package.
The SSIS server – improving the deployment and management for the SSIS packages.
No more need for dependency on the login name and password of the package administrator or the SQL Server Agent. Administration is now through the server.
We can migrate from SSIS older version to newer version and we can also decide if we want to downgrade.
Environments – sets of values that can be supplied to the packages.
Entry point package – a few packages in one project can be the entry point in that project. We have an easy way to identify them and give them the parameters.