Knight's Microsoft® Business Intelligence 24-Hour Trainer: Leveraging Microsoft SQL Server® Integration, Analysis, and Reporting Services with Excel® and SharePoint®

28



LESSON 4 Understanding ssis

The Execution Results tab will provide a detailed listing of every step of the package including vali-

dation and the execution of each task contained within the package. If a warning occurs it will be

designated with the following icon

. If an error occurs there will be at a minimum two statements

indicating the failure. The first will provide the details of the error, and the second usually just states

that the task has failed. The results will be similar to what is shown in Figure 4-7.

FIGURE 47

Note that the first line provides the details of the error and the second states which task failed.

TRY IT

In this Try It you will first create a solution and a project. Once these are complete, you will create

an extract file that contains a list of the name of every person from the Person.Person table in the

AdventureWorks2008 database.

Lesson Requirements

In this lesson you will create an Integration Services project. Then you will create an SSIS package

that will read the contents of the Person.Person table. You will add a new column to the result set that

will contain the person’s first and last names as one field.

The download for this lesson available at www.wrox.com includes the solution

for this Try It.

Hints

Developing Integration Services projects requires a development environment. BIDS provides a com-

prehensive tool set for developing, testing, debug