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 |
|
surefooted
Posting Yak Master
188 Posts |
 Posted - 2005-05-17 : 16:08:29
|
Hello all,I have a pckage that reads a list of tablenames, delete the tables, then copies the talbes from one db to another. I cannot figure out how to get the column mappings to update when the destination and source changes. It returns 'Column Name X was not found.' I have used the disconnect edit and see that the source and destination columns are update properly, it just isn't updating the column names and definitions.Any help is greatly appreciated.Thanks,surefooted.-JonShould still be a "Starting Member"  . |
|
|
SreenivasBora
Posting Yak Master
164 Posts |
Posted - 2005-05-17 : 18:28:13
|
| Hi,As per your mail, you are saying that with a DTS package, first you are deleting all the tables and copying the tables from one database to other. Fine. If that is so, what is the point you are worry about the columns ? I feel what is there at SOURCE_DB tables you are copying into DESTINATION_DB with same table structures and just copying the data.Try like this ...1. Read all the tables in a List 2. Delete all the tables (Use If Exists(select name from sysobnjects where xtype = 'U' and name = 'Source_Table1') then DROP table Source_Table1)3. Select * into Dest_Table1 from dbo.Source_Table1With RegardsSreenivas Reddy B |
 |
|
|
|
|
|
How to update column mappings dynamically??