Connection Projects in Visual Studio
Microsoft is trying to make it easier to get data sources or data targets defined and ready to utilize with SSIS packages. From Visual Studio, you can now create an Integration Services Connection project. A wizard takes you through defining the data sources and connections for an SSIS package. As you can see in Figure 52.44, this wizard allows you to jumpstart the data source/connection managers you might need for a new SSIS package.
Figure 52.44 The Visual Studio Integration Services Connection Project Wizard.
You can then step through the buildup and testing of the connection one connection manager at ...
Get Microsoft® SQL Server 2008 R2 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
