In my previous post I wass looking for the Data Sources and Data Source Views in SSIS 2012 projects. As Carla Sabotta (site|twitter) mentioned in the comments you can change the deployment model of your project so the Data Sources folder will reappear. To do this right click the project in Solution Explorer and choose for “Convert to Package Deployment Model”:
After this a warning will appear that you won’t be able to convert to the Package Deployment Model if you are using new features. So when I try to convert the package I created in my previous post I get a nice error report and clicking on the details I get the exact error why my project couldn’t be converted:
When I take another (empty) project without Project Connection Managers the conversion succeeds and a Data Sources folder shows up in my Solution Explorer:
Also note the explicit mention in the project name that we are working in the Package Deployment Model.
So now I can define my Data Sources again like I used to do with SSIS 2005⁄2008.
As a conclusion we can say that there is a change in working with and deploying SSIS 2012 Projects. In the pre 2012 era the packages were handled als fully contained, stand alone packages. Where in SSIS 2012 you can start defining items at the project level and these are inherited by the packages itself.
But I still haven’t found my Data Source Views.