Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
killer2002
Starting Member
12 Posts |
 Posted - 2003-03-25 : 05:14:55
|
| Can you make the tablename and destinationname dynamic?? |
|
|
samsekar
Constraint Violating Yak Guru
437 Posts |
Posted - 2003-03-25 : 05:27:58
|
| We can use Dynamic SQL. Can you make your question more precise it is not clear. Sure somebody can help you.Sekar~~~~Success is not a destination that you ever reach. Success is the quality of your journey. |
 |
|
|
killer2002
Starting Member
12 Posts |
Posted - 2003-03-25 : 05:37:51
|
| In the DTS designer i update a table called "customers" this table is also copied to another database.But now my question is: can you copy a table to antother database even though you not know the tablename.I know it can be done with:Copy SQL Server Objects Task but i dont want to copy a whole database only the table i specify.I hope it's clear now |
|
|
|
|
|
|
dynamic tables-names