Re: DTS

From: Frederico Fonseca <real-email-in-msg-spam@xxxxxxxxx>
Date: Wed, 25 May 2005 00:17:08 +0100

On 24 May 2005 15:17:34 -0700, "Kelly" <vkforfun@xxxxxxxxx> 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
.

References:
- DTS
  - From: Kelly

Prev by Date: DTS
Next by Date: Re: Occurs Depending Memory Use
Previous by thread: DTS
Next by thread: Re: DTS
Index(es):
- Date
- Thread

Relevant Pages

Re: SQL 2000 - Connection Error with DTS Packages
... After I changed all SQL Server 'Database Connection' steps in each of my DTS ... Package" option when you right click a DTS package name in ME. ...
(microsoft.public.sqlserver.dts)
Re: file conversion from SQL Server to Access
... You want to take data and table structure from SQL Server to Access? ... You can also have DTS create the destination tables for you. ... Is there a Northwind database ... >> www.konesans.com - Consultancy from the people who know ...
(microsoft.public.sqlserver.dts)
Re: Audit of sql server
... The DTS database transfer makes sense now. ... >> SQL Server will not check on this for you. ... >> Compiles each query but does not execute it. ...
(microsoft.public.sqlserver.programming)
Re: cannot open database requested in login
... Is the connection object using Windows Authentication? ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. ... > I have a DTS replication which truncates the destination> of one database and copies all the rows from the source> table of another database of same serverin> first step. ...
(microsoft.public.sqlserver.dts)
Re: DTS Performance
... Make sure the log and data file size are not going to need to expand during the import ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... www.SQLDTS.com - The site for all your DTS needs. ... > this database is 2.74 GB and the database itself is 2.67 GB. ...
(microsoft.public.sqlserver.dts)