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

Control Flow Design

An Execute SQL Task is a control flow item which can be chosen from the Control Flow tasks in the Visual Studio IDE's Toolbox as shown in Figure 10.  You can see the large number of tasks added in SSIS (Compare to those in DTS, Figure 1).  In the next section a task is added.

Figure 10

 

 

Add an Execute SQL Task

From the task list click and draw an Execute SQL Task on the design pane of the editor with the tab Control Flow chosen as shown below.  When you right click on this component you can access the drop-down menu from which various items can be accessed or performed.

Figure 11

 

Edit the SQL Task

Click on the Edit...menu item to open the window.

Figure 12

 


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-2024 ASPAlliance.com  |  Page Processed at 2024-03-28 12:42:23 PM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search