Edit

Lesson 2-4: Test the Lesson 2 tutorial package

  • Article

Applies to: SQL Server SSIS Integration Runtime in Azure Data Factory

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 AdventureWorksDW2022 database before you run the package from this lesson. Lesson 2 attempts to insert records already inserted in Lesson 1, which causes an error.

Check the package layout

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

Control flow in package

Data Flow

Data flow in package

Test the Lesson 2 tutorial package

  1. 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.

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

Go to next lesson

Lesson 3: Add logging with SSIS

See also

Execution of projects and packages