Sunday, February 26, 2012

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
KellyI'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

No comments:

Post a Comment