DEBUGGING AN SSIS PACKAGE

Debugging an SSIS package is the process of systematically monitoring, analyzing, and modifying the control and data flows within the package to ensure it performs as expected, including handling errors, managing data transformations, and validating logic. To do this;

1. On the Debug menu, select Start Debugging.

2. The package runs, resulting in 1,097 rows successfully added into the NewFactCurrencyRate fact table in AdventureWorksDW2022. To verify this result, select the Data Flow tab.

3. Go to our database,right click on tables and refresh

4. Go to dbo.NewFactCurrencyRate, right click on it and click ‘select top 1000 rows’

5. Write the code select * and you will see that the total number of selections will be 1,097. This means we were successful in our project

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