Data Flow
Flexible Authoring
Change in CTP 1: It's now possible to edit a component even when its input path is disconnected.
Simplified Data Viewer
The Data Viewer can now be configured directly from the Data Flow Path editor. The data viewer only supports a grid view, the histogram and scatter plot views have been removed (but who has ever used them?).
An other time saver: just one right and one left click. |
I only get a little error message when I execute the task and close the data viewer.
Error message when closing data viewer |
Source & Destination Assistant
Added in CTP 1: the Source Assistant and Destination Assistant. Feels a little bit like SSIS for Dummies... and there isn't a flatfile target.
They are extra. |
After the OK, you will get the regular screens. |
Grouping in dataflow
Very useful for large dataflows is the new collapsible grouping option.
Dataflow grouping |
Data Correction / DQS Cleansing
The new data flow object I mentioned in my CTP 1 review is gone (was not yet working there), but a new transformation has been added: DQS Cleansing. Will check it out later on. See also Data Quality Services.
DQS Cleansing |
Pivot
I expected a better editor. Unfortunately no improvements yet... See/vote this request at Microsoft Connect.
Still the user unfriendly editor |
No comments:
Post a Comment
Please use the SSIS MSDN forum for general SSIS questions that are not about this post. I'm a regular reader of that forum and will gladly answer those questions over there.
All comments are moderated manually to prevent spam.