Hi,

I have to get some data in my Sql Server database and update one another
table in my Oracle database with these data (using DTS).

1) What is the best Task should I use to build the package in DTS ?
2) I have the fields to avoid the relationship between those database, but I
don´t know how to make these relation in DTS

I tried to use DATA DRIVEN QUERY TASK but I didn't have success...I got lost
when I had to make the relationship...

Can someone help me ?
tks
Ed

the DDQ is a good option.

you have to map the source columns to destination columns and , in an
ActiveX transformation between (at least) 1 source column and 1 destination
column set the return value to "update"

main = DTSTransformStat_UpdateQuery

then , in the queries, select the "update" option and type your Update SQL
command like
update destinationtable
set column1 = ?, column2 = ?, column3 = ?, ...
where keycolumn = ?

and finally, map each parameter to the related column. You'll see "parameter
1", "parameter 2"... in the same order has your ? characters.

In the BOL of SQL Server look at this section : "
Data Driven Query Example: Changing Customer Accounts "
there is a complete sample.

"Ed" <etroqui (AT) hotmail (DOT) com> wrote

The DDQ Task is IMHO slow and you will be slow enough coverting from SQL
Server to Oracle in any event so what i would personally do is

Export to file
FTP the file over to Oracle
SQL*Loader to get the file in
Issue a series of Update statements on Oracle.

This can still all be done through DTS.

OR

DataPump to Oracle
Update statements after that.

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Ed" <etroqui (AT) hotmail (DOT) com> wrote