SSIS 2011 – what’s planned for the new version

May 30, 2010

This is continued live blogging from the Donald Farmer seminar from the SQL & BI convention in Tel Aviv of Data Integration in Large Organizations.


 


The roadmap for SSIS 2011 – what will exist in the future version of Integration Services 11


Today everything exists in a package.
In SQL Server 2011 there is an SSIS Server which uses SQL Server OS to manage data flows without being confined to a package. Most of the work is around building the server and the tools to manage the server.


A new designer interface which will be built around common tasks.
A designer with a walkthrough according to the functions or transformations that you’ve added.


MetaData management: 



  1. Where does the data come from

  2. What is affected from the package downstream – cube, SharePoint list

Add comment
facebook linkedin twitter email

Leave a Reply

Your email address will not be published.

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

*