While I’m still preparing to teach a MS6235A SSIS training I use a SQL 2012 RTM environment to test the demo’s. One of the demo’s is to show how a Connection Manager is made based on a Data Source View. In BIDS 2008 the Data Sources and Data Source Views are found in the Solution Explorer:
To create a new Data Source you right click on the Data Source folder and follow the wizard:
Next you would make a Data Source View based on the Data Source just created by right clicking on the Data Source View folder and again following the instructions:
In the screen that pop’s up you get the list of available Data Sources and after selecting one the Connection Manager is created.
The last step is to create the Connection Manager that will be based on the Data Source. This is accomplished by right clicking in the Connection Manager pane and by selecting “New Connection From Data Source…”:
To use the Data Source View a “Data Flow Task” must be created and in the task an “OLE DB Source” is used. When configuring the OLD DB Source you can finally refer to the Data Source View:
Now when I try the same scenario with the new “SQL Server Data Tools” you can immediatly see that there are no Data Sources and Data Source Views in the solution explorer:
What you can see is a Connection Managers folder. Right clicking the folder gives me the option to create a new Connection Manager. In the wizard I connect to my AdventureWorks2012 database and when I complete the wizard my Solution Explorer shows the new Connection Manager:
But more important when you look at the Connection Managers pane in the package itself you’ll see that there is a “(project)ConnectionManagerName” added to the package:
And this Connection Manager can be used from within an OLE DB Source control.
So with the new Data Tools for SQL Server 2012 it looks like we’ve lost the Data Source Views for SSIS projects. But creating Data Sources in the project scope stays possible altough it’s now renamed to Connection Managers.