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

Overview of this tutorial

The basic steps consist of configuring the Control Flow and the Data Flow pages in the designer.

·         The control flow configuration starts by first creating a table with the same schema as the          Oracle 10 XE's "Departments" table using an SQL statement.  Once this SQL procedure is created and executed, the table will be created (with no data) in the SQL 2005 Server's SsisEditor database.

·         The Data Flow is configured by configuring the OLE DB Editors for the two servers.  However, for completing the configuration, all information including the tables on the two databases must be specified.  And unless the empty table with the same structure as the oracle database is present in the SQL 2005 Server, the specification will not be met. 

·         In order to complete the package, the Control Flow task is executed to create the table in the SQL 2005 Server and then the design of the Data Flow Task is completed.  In order not to complicate the procedure this method has been used in the course of this tutorial.

 

Here is list of preparatory items that are needed for this project to succeed.

·         Both SQL Server 2005 and Oracle 10G XE should be functioning correctly.

·         SQL Server 2005 should be properly configured and tested.

·         Authentication and permissions should be in place for the objects accessed.

·         An Instance of VS 2005 should be available.

·         SQL Server 2005 being the destination, the database to which the table will be brought in should be in place by creating an empty database named SsisEditor.

·         The TSQL Script to create a table in SQL 2005 server, which is a copy of the table from
Oracle 10G XE, should be available or capable of being created in the IDE.

For both Oracle and SQL 2005 server, OLEDB providers will be used.


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-21 9:30:40 PM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search