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.
- Where does the data come from
- What is affected from the package downstream – cube, SharePoint list