Floating FB popout byF5debug

SQL Server Integration Services (SSIS) – Part 5 – Building and Executing a Package

 

This is part 5 of the series of article on SSIS. In this article I have described how to build and execute a package in SSIS.

Introduction

In this article we will look into how to build and execute a package in SSIS. The idea behind this article is the reader should get familiar with the options available in executing 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.

[more]

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 at the below URL.

You can look into my series of article on SSIS at the url - http://f5debug.net/all-articles/

So Once we are ready with creating tasks and preparing a format to perform some tasks as shown in the below screen we will see how to build and execute the SSIS packages

clip_image001

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. Is 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 Build menu and click on BuildDebugandExecute

clip_image002

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

clip_image003

Now in order to do the execution debug and check if the process goes on step by step Go to Debug menu and click on Start Debugging or Press F5 directly as shown in the below screen

clip_image004

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 below screen

clip_image005

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

Conclusion

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

About Author: Karthikeyan Anbarasan, Microsoft MVP (Most Valuable Professional) in ASP.NET/IIS Architecture. He is the Founder and Chief Editor of the www.f5debug.net website and has authored books on Windows Phone and Business Intelligence(SSIS). He is also a Passionate Speaker and a Blogger on Microsoft Technologies.

You can Join Me On: Facebook, Twitter, Google Plus, LinkedIn

Comments (1) -

prabhu
prabhu
11/26/2013 5:10:09 AM #

yes

Add comment

  Country flag

biuquote
  • Comment
  • Preview
Loading

Recent Posts

Random Posts

Most Viewed

URL Shortner

Create your own short urls!!!

Site Counter

free counters

Disclaimer

This is a personal weblog. The opinions expressed here represent my own and not those of my employer. For accuracy and official reference refer to MSDN/ TechNet. I have documented my personal experience on this blog.

Protected by Copyscape Web Plagiarism Finder

Site Meter