DTS

I have a question regarding DTS in SQL Server, I am trying to match
tables that are present in Databse A to Database B. I Know to match the
columns but I am not aware of how exactly can i transfer values of
tables present in databse A to tables present in database B.

Is there anyone who can help me with this.

Thanks in advance
Kelly

On 24 May 2005 15:17:34 -0700, "Kelly" <vkforfun@yahoo.com> wrote:

>I have a question regarding DTS in SQL Server, I am trying to match
>tables that are present in Databse A to Database B. I Know to match the
>columns but I am not aware of how exactly can i transfer values of
>tables present in databse A to tables present in database B.
>
>Is there anyone who can help me with this.

And what does this have to do with COBOL?

But you do that with an insert or/and an update sql statement.
DTS package creator is very helpfull on this, so do try it out




Frederico Fonseca
ema il: frederico_fonseca at syssoft-int.com

> I Know to match the
> columns but I am not aware of how exactly can i transfer values of
> tables present in databse A to tables present in database B.

I think that you are asking how you access the data items from two
tables in a single select via a cursor.

Something like:

DEFINE ... CURSOR FOR
SELECT * FROM A, B WHERE A.value > 1000.00 and B.code = A.code

FETCH ... (A.code, B.name) INTO :code, :name