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