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

SQL DTS Flashback

In order to see how differently SQL Server Integration Services accomplishes the same task, it will be helpful to see how it was done with DTS.  Some of the DTS concepts are the same in SSIS.  Using a connection to SQL 2000 Server, an ODBC connection to Oracle 10G XE server and a Transform Data Task are all needed to accomplish the task in DTS.  Using these components, the copying process can be designed into a DTS Package as shown in Figure 2.  Although Transform Data Task has a limited repertoire, it does copy tables admirably well.  It even has a "Copy Table" Transform Data Task which is not seen in the Visual Studio 2005 IDE.  Thus, this flashback may not be comparing apples with apples, but it at least shows that the underlying concepts are not radically different.

Figure 2

 
 


View Entire Article

User Comments

Title: Question   
Name: Ram
Date: 2/16/2012 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: 5/9/2011 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: 4/22/2010 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: 10/23/2009 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: 7/15/2009 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: 6/8/2009 3:03:01 AM
Comment:
Very useful article for beginners !

Product Spotlight
Product Spotlight 





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


©Copyright 1998-2014 ASPAlliance.com  |  Page Processed at 4/25/2014 5:24:28 AM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search