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 |
|
gregger
Starting Member
19 Posts |
 Posted - 2004-02-02 : 12:24:57
|
| Greetings All,I am new to creating packages and I would like to ask a question.How can I create a DTS Package to connect to my webhosting sql server and:1. Download data to local sql server 2. Delete the data that was downloaded?I am familiar with using the DTS Package tool to build a package to download the data. Getting that far was pretty simple. I used the graphical tool to drag and drop a "Copy SQL Server Objects Task" and changed properties to download data. Under the Copy Tab I unchecked the "Create Destination Objects" and checked the "Copy Data" checkbox. I would like to append the data on server to the existing table on my local SQL Server.Is it possible to execute a Delete statement after the data is downloaded to local sql server?Thanks.Gregg |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-02-04 : 15:51:56
|
| Yeah, look at the Execute SQL Task and attach it to part of your workflow...Brett8-) |
 |
|
|
|
|
|
How to:Create a package to download & delete data