DTS Wizard, HELP!!!

  • Thread starter Thread starter Virat
  • Start date Start date
V

Virat

Hey All,
First, my introduction, I am Virat, a student of MCA (Master of
Computer Applications) I am in my final semester doing a project with
a company in Chennai, India.I have done a few programs in VB-Oracle 9i
for my academic labs. And understand basic queries and Oracle command.

Now, the question that I have is that I have to do this project for
the company where I am doing my Internship. The problem statment is as
follows:

I am supposed to develop a tool like DTS (Data Transfer Service)
Wizard available in SQL Server 7.0. In which I have to transfer data
from:
1. SQL Server 7.0
2. Microsoft Access
3. Microsoft Excel
4. Flat Files (CSV - Comma Seperated Values and Fixed Length)
to Oracle 9i and back to respective sources.

Also, I have to take care of the following Performance Parameters:
1. Data Integrity during transfer.
2. Speed of transfer.
3. Any Issues faced while doing this project.
4. Multiplexed (Forward and Backward Data Movement, ie. import/export
between above mentioned softwares.)

Now, my problem is I am new to databases and do not know how to go
about this problem. Can anyone please help me in this regard?

Thanks,

Regards,
Virat
 
The first thing you'll need to do is know how to connect to each datasource.
You may want to check out www.connectionstrings.com . That'll prime you for
connecting to each of the datasource. To write to excel, for instance,
you'll need to use some COM interop and there's a good example about writing
to excel here... http://www.codeproject.com/dotnet/ExportExcelData.asp

This http://www.knowdotnet.com/articles/exceldatasource.html article will
show you how to query an excel data sheet for data. You'll need to use the
System.IO to create delimmited files --- ado.net will allow you to connect
to most delimmited files.


You will probably also want to use SQL-DMO because it's quite powerful and
you can use it to locate SQL Servers on a network. I'm not sure what the
orace equivalent is, but I've used stuff before that identifies every oracle
db on a network so it's probably no more difficult than using DMO.

I'm not sure if you need to include a scheduler, but that will probably be
on of the eaiser parts to set up.

Anyway, this should give you a decent starting point b/c alot of it is going
to be firing DDL commands and then firing DML against the new objects.
This is pretty generic, but if you need something more specific, let me know
and I'll try to help.

Good Luck

Bill
 
Back
Top