Task 9: Testing the Lesson 1 Tutorial Package

In this lesson, you have done the following tasks:

  • Created a new SSIS project.

  • Configured the connection managers that the package needs to connect to the source and destination data.

  • Added a data flow that takes the data from a flat file source, performs the necessary Lookup transformations on the data, and configures the data for the destination.

Your package is now complete! It is time to test your package.

Checking the Package Layout

Before you test the package you should verify that the control and data flows in the Lesson 1 package contain the objects shown in the following diagrams.

Control Flow

Control flow in the package

Data Flow

Data flow in the package

To run the Lesson 1 tutorial package

  1. On the Debug menu, click Start Debugging.

    The package will run, resulting in 1097 rows successfully added into the FactCurrencyRate fact table in AdventureWorksDW.

  2. After the package has completed running, on the Debug menu, click Stop Debugging.

Next Lesson

Lesson 2: Adding Looping

Integration Services icon (small) Stay Up to Date with Integration Services

For the latest downloads, articles, samples, and videos from Microsoft, as well as selected solutions from the community, visit the Integration Services page on MSDN or TechNet:

For automatic notification of these updates, subscribe to the RSS feeds available on the page.

See Also