Home > Archive > Microsoft SQL Server forum > May 2005 > DTS









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author DTS
Kelly

2005-05-24, 8:24 pm

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

Simon Hayes

2005-05-25, 3:23 am

I'm not sure what you mean - what does "matching" the tables mean? The
basic way to transfer data is to create two MSSQL connection objects,
and use a Transform Data task to copy the data. Have you tried this?

If this doesn't help, I suggest you give some more information - what
version of MSSQL, what exactly you need to do, what exactly you've
tried so far etc.

Simon

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com