1158
Part IX: Business Intelligence
FIGURE 52-2
Target table in Adventureworks (two views, one including the foreign key reference to
Product).Creating a Basic SSIS Package Inside SQL Server Data Services
You can develop SSIS projects inside a shell of Microsoft Visual Studio called SQL Server
Data Tools (SSDT). SSDT is the replacement for Business Intelligence Development Studio.
It contains the new SSIS toolbox and other features like the zoom bar on the lower right
corner.- Open SSDT by clicking Programs ➪ Microsoft SQL Server 2012 ➪ SQL Server Data
Tools from the Start menu. - To start a new project, select File ➪ New ➪ Project. If SQL Server is all that you
have installed on your machine rather than the entire Visual Studio suite, you see
only the Business Intelligence templates as options for projects. - Select Integration Services Project from the list of available templates, navigate
to the wanted fi le location in which to create the project, name it, and click OK.
Figure 52-3 represents a newly created SSIS project.
On the upper-right side of your environment, you see the Solution Explorer. This is native
to Visual Studio. You look at it because SSDT is a shell of Visual Studio. This is where pack-
ages are added, named, and deleted from your Project.
Deprecated Feature
The Data Source View has been deprecated in SSIS in SQL Server 2012. The need for Data Source
Views has been eliminated by Shared Connection Managers.c52.indd 1158c52.indd 1158 7/31/2012 10:29:25 AM7/31/2012 10:29:25 AM
http://www.it-ebooks.info