| description | Lesson 2-4: Test the Lesson 2 tutorial package |
|---|---|
| title | Step 4: Test the Lesson 2 tutorial package | Microsoft Docs |
| ms.custom | |
| ms.date | 01/03/2019 |
| ms.prod | sql |
| ms.prod_service | integration-services |
| ms.reviewer | |
| ms.technology | integration-services |
| ms.topic | tutorial |
| ms.assetid | 0e8c0a25-8f79-41df-8ed2-f82a74b129cd |
| author | chugugrace |
| ms.author | chugu |
[!INCLUDEsqlserver-ssis]
With the Foreach Loop container and the Flat File connection manager now configured, the Lesson 2 package can iterate through the 14 flat files in the Sample Data folder. Each time a file name matches the specified criterion, the Foreach Loop container populates the user-defined variable with the file name. This variable, in turn, updates the ConnectionString property of the Flat File connection manager, which connects to that flat file. The Foreach Loop container then runs the unmodified data flow task against the data in that flat file.
Note
If you ran the package from Lesson 1, you need to delete the records from the dbo.NewFactCurrencyRate table in the AdventureWorksDW2012 database before you run the package from this lesson. Lesson 2 attempts to insert records already inserted in Lesson 1, which causes an error.
Before you test the package, verify that the control and data flows in the Lesson 2 package contains the objects shown in the following diagrams. Lesson 2's data flow is the same as Lesson 1.
Control Flow
Data Flow
-
In Solution Explorer, right-click Lesson 2.dtsx and select Execute Package.
The package runs. You can verify the status of each loop in the Output window, or by selecting the Progress tab. For example, you can see that 1,097 rows were added to the destination table from the file Currency_VEB.txt.
-
After the package has completed running, on the Debug menu, select Stop Debugging.