Step 9: Testing the Lesson 1 Tutorial Package
Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).
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.
To run the Lesson 1 tutorial package
On the Debug menu, click Start Debugging.
The package will run, resulting in 1097 rows successfully added into the FactCurrency fact table in AdventureWorksDW2012.
After the package has completed running, on the Debug menu, click Stop Debugging.