SQL Server Integration Services (SSIS) - Building and Debugging a Package

Introduction

This article will look into how to build and debug a package in SSIS. The idea behind this article is for the reader to become familiar with the options available for executing and debugging the package to check for any errors or to see if the package is executed correctly or not. Finally, in the next article, we will look into the deployment strategies for SSIS.

Steps

To see the building and the execution process of SSIS, we will first create a solution (project) and do some tasks, which you can see in my Part 1 to Part 4 Series on the step-by-step process.

So once we are ready to create tasks and prepare a format to perform some tasks, as shown in the following screen, we will see how to build and execute the SSIS packages.

I have performed two tasks here; one is from an OLE DB connection (SQL DB) Northwind Database in the products table. If there is any problem with the source, then it will transform into Flat File. I'm taking product values > 25 to an excel sheet.

So once we are ready with the project tasks, go to the Build menu and click BuildDebugandExecute.

At the bottom of the window (Status bar), you can see the status of the build as shown in the following screen:

Now to debug it and ensure that it executes properly, go to the Debug menu and click on Start Debugging or Press F5 directly, as shown in the following screen:

The execution process starts, and the tasks will be executed step by step. The completed tasks will be shown in green color as shown on the following screen:

If there is any error in the process tasks, the task will be shown in RED color.

Conclusion

We have gone over how to build and execute the SSIS package. We will look into the deployment options and techniques in the upcoming articles.