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 |
|
RooHoo
Starting Member
11 Posts |
 Posted - 2003-03-15 : 19:10:30
|
| I am trying to do this in a DTS package. Open the connection, create 3 new tables from my main table, 1 each for the completed, not worked and those orders that need followed up. Goal is to replace each existing table, using the same name. I have figured out the data flow, but deleting/replacing an existing table has me stumped.Any help is greatly appreciated.Thanks |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2003-03-15 : 22:02:24
|
| Use an Execute SQL Task? I don't get it ... what's to figure out ...Actually, from your description, these requirements don't seem to warrent a DTS solution. You should be able to do all this in a stored proc...Is there more to the story?Jay White{0} |
 |
|
|
RooHoo
Starting Member
11 Posts |
Posted - 2003-03-16 : 06:55:43
|
| I SAID I was new at this! For some reason it wouldn't delete the table. I must have had my flow wrong or something. I tried it again and it worked. I haven't learned Stored Procedures yet.Thanks |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-03-16 : 10:34:57
|
| See below.DTS is a external application and not much to do with the database.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
Newbie Needs to Drop/Replace Table using DTS