Microsoft® SQL Server® 2012 Bible

1167

Chapter 52: Building, Deploying, and Managing ETL Workfl ows in Integration Services

52

1. Get in the habit of good formatting: Select all four of the components in the data
   fl ow by holding the control key and clicking them.


2. Click the Format menu. Select MakeSameSize ➪ Both.


3. Click Format again. Select AutoLayout ➪ Diagram.


4. To run, go to the solution Explorer and select the package.


5. Right-click and select Execute Package. You see a yellow circle appear in the upper
   right hand corner of a task to signify beginning, a green circle with a checkmark
   for success, and although you shouldn’t see this for this example, a circle with a red
   “x” for failure.


6. Check the number of rows loaded by clicking the Data Flow tab.

The package has now been created with all the specifi ed requirements met.

Exploring the SSIS Environment in More Detail

The fi rst section of this chapter gave a quick overview of some basic elements of SSIS. The

following section offers a more complete guide to the features of SSIS.

Using Connection Managers

Recall that a connection manager is a wrapper for the connection string and properties

required to make a connection at run time. The following sections represent types available

and confi guration options to consider

What’s New in SQL Server 2012

The keystone added feature of SSIS in SQL Server 2012 is the Project Deployment Model, where Projects

are now the basic unit of SSIS. To this end, there is now the ability to create Connection Managers at

the Project level. You create these once, read from all packages in the Project unlimited. The shared

Connection Managers appear bolded inside the packages. Shared Connection Managers have a node

under the Project in Solution Explorer. Right-click this node and select New. The Connection Manager

Dialog boxes are the same whether you confi gure a Connection Manager at the project or package level.

Using Database Connection Managers

Defi ning database connections through one of the available connection managers requires

setting a few key properties:

■ (^) Provider: The driver to be used in accessing the database
■ Server: The server or fi lename containing the database to be accessed
c52.indd 1167c52.indd 1167 7/31/2012 10:29:27 AM7/31/2012 10:29:27 AM
http://www.it-ebooks.info