Building a SQL Server 2005 Integration Services Package Using Visual Studio 2005
page 3 of 11
by Jayaram Krishnaswamy
Feedback
Average Rating: 
Views (Total / Last 10 Days): 103230/ 270

Creating a SSIS Project and adding a Package

The starting point in creating a package is to create a Business Intelligence Project using the Integration Services Project - a standard Visual Studio 2005 installed template as shown in Figure 3.  It has been given a name here, Editor Basics.

Figure 3

 

 

 

This creates the EditorBasics project in the Solution Explorer as shown below.  It comes with the folders, Data Sources, Data Source Views and SSIS packages.  You could further expand this node to see its contents.  By right clicking this node, you reveal the drop-down menu from which you can do a number of things.  Click on the New SSIS Package menu item.

Figure 4

 

You could also create a new package as shown in Figure 5.  This figure shows other details for the Package1.dtsx [Design] tab as well.

Figure 5

 

 

The Package consists of the following: Control Flow, Data Flow, Event Handlers, and Package Explorer.  More items may show up during package development.  Please read the grayed text Control Flow of the package, this explains how to configure this part.  The pane in the bottom is where the connections are placed called the Connection Managers.

Figure 6

 

 

The Data Flow page shows the data flow tasks that are needed by the package.  You can click on the link to add the Data Flow task(s) as shown below.

Figure 7

 

 

In the Event Handlers page, for each task configured you could attach an Event Handler (default OnError).

Figure 8

 

 

The Package Explorer is an explorer style list of all items in the package.

Figure 9

 


View Entire Article

User Comments

Title: Question   
Name: Ram
Date: 2012-02-16 2:22:59 PM
Comment:
I have installed Visual Studio 2005, but when I open Visual studio, I am unable to see the template 'Integration Services Project'. Any ideas?
Title: Big brother   
Name: Hussein Negm
Date: 2011-05-09 6:04:31 AM
Comment:
Thanks a lot man! this article as roob said is a big help and the detailed explanation really helped a lot to begin using this tool. I wish you'd do more tutorials for more advanced capabilities :)
Title: Just the right article!   
Name: Roob
Date: 2010-04-22 11:55:25 AM
Comment:
This article helps remove the fear of the unknown for those experienced in SQL < 2005 that are yet to make the change.
Title: Building a SQL Server 2005 Integration Services Package Using Visual Studio 2005   
Name: Ram
Date: 2009-10-23 9:26:41 AM
Comment:
very nice
for a beginner very nice step to teaching
Title: Building a SQL Server 2005 Integration Services Package Using Visual Studio 2005   
Name: Jayaram Krishnaswamy
Date: 2009-07-15 12:33:32 PM
Comment:
If you liked this article you may want to read to of my books written in the same style. Links to books and sample chapters are on my URL.

Thanks

Jay
Title: Building a SQL Server 2005 Integration Services Package Using Visual Studio 2005   
Name: Sraswathi
Date: 2009-06-08 3:03:01 AM
Comment:
Very useful article for beginners !

Product Spotlight
Product Spotlight 





Community Advice: ASP | SQL | XML | Regular Expressions | Windows


©Copyright 1998-2018 ASPAlliance.com  |  Page Processed at 2018-10-22 9:21:55 PM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search