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 |
|
wotrac
Yak Posting Veteran
98 Posts |
 Posted - 2005-02-27 : 13:43:32
|
| How do I go about deleteing all the records from an MS Accesstable in the destination database, before copying the recordsfrom my source sql data.Or is there a better way of doing this.Could someone also point me in the direction of a good source of info on DTS |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-02-27 : 14:28:25
|
| www.sqldts.comMeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2005-03-24 : 10:10:47
|
| Use DTS. In "SELECT SOURCE TABLES AND VIEWS" option click TRANSFORM and select DELETE ROWS AT DESTINATION...------------------------I think, therefore I am |
|
|
|
|
|
|
Drop Table / Delete