It’s very interesting to see small small changes on development interface of SQL Server Data Tool in SQL server 2012. Now BIDS is gone it’s data tool that introduced in SQL Server 2012 version for the development of BI projects.
Here is the first impression after using this interface. Very first that you can notice re-organization of component in tool box with new icons that gives you more glossy look. I’m using SSIS interface where you can notice four changes.
1. Project Level Parameter: It’s a new implementation to avoid using SQL level configuration that could be shared across multiple projects. Similar functionality you can achieve by suing this project level parameter.
2. Re-Organized toolbox: I like this very much, they organized component based on their usability and nature like putting all container tasks in one bucket.
3. Zoom Slider: Zoom slider is bigger and better. you can easily notice and easily use it.
In case of data flow you will also see some difference. There are organized as per usability, Added a new group favorite in tool box. most importantly where component was grouped in Extract, Transform and then Load that represent to ETL where as in new component grouping common transformation are on top. It’s improve usability for SSIS developer.
Comments