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 |
|
Kristen
Test
22859 Posts |
 Posted - 2004-07-21 : 16:05:24
|
| I know diddly squat about DTS, so I'd appreciate some help.I have a client who is transferring a table from ServerA to ServerB overnight.The table is part of a development project and is subject to quite frequent changes of structure.Is there some way to get DTS to do the equivalent of a SELECT * INTO MyTable so that any newly added columns are copied too? rather than having to re-make the Package each time?ThanksKristen |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-07-21 : 16:37:29
|
| Not really, but then why can't you useDROP TABLE ServerB.DBName.dbo.TableNameSELECT *INTO ServerB.DBName.dbo.TableNameFROM DBName.dbo.TableName (this would be run on ServerA)?Tara |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2004-07-21 : 18:57:56
|
| That'll do the trick, thanks Tara.Kristen |
|
|
|
|
|
|
DTS when Column List changes