.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Articles >> DataBase >> Post New Resource Bookmark and Share   

 Subscribe to Articles

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

Posted By:Karthikeyan Anbarasan       Posted Date: February 27, 2011    Points: 100    Category: DataBase    URL: http://www.dotnetspark.com  

In this article we will look into how to build and execute a package in SQL Server Integration Services (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.


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's

Part 1

Basics of SSIS and Creating Package - SQL Server Integration Services (SSIS) - Part 1

Part 2

Transforming SQL Data to Excel Sheet - SQL Server Integration Services (SSIS) - Part 2

Part 3

Export Data using Wizard - SQL Server Integration Services (SSIS) - Part 3

Part 4


Import Data using Wizard - SQL Server Integration Services (SSIS) - Part 4

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


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


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


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


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


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.

 Subscribe to Articles

     

Further Readings:

Responses

No response found. Be the first to respond this post

Post Comment

You must Sign In To post reply
Find More Articles on C#, ASP.Net, Vb.Net, SQL Server and more Here

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend