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


Introduction

In this article we 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 and finally in the next article we will look into the deployment strategies for SSIS.

Steps

In order to see the building and the execution process of SSIS, we are first going to 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 with creating tasks and preparing 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 2 tasks here, one is from a OLE DB connection (SQL DB) Northwind Database in products table I'm taking product values > 25 to an excel sheet. If there is any problem with the source then it will transform them to Flat File.

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


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


Now in order 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 and the completed tasks will be shown in green color as shown in the following screen:


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

Conclusion

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