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 |
|
jrockfl
Posting Yak Master
223 Posts |
 Posted - 2004-06-20 : 16:01:19
|
| I have a DTS package runs daily and copies a data from the local network to the remote web server. It drops the table, creates it, then uploads the data.I would like to be able to update the table on the web server, instead of dropping and recreating. I was directed to Data Driven Query Task, but cant see to get this working. I have only create DTS packages with the wizard.Is there any good tutorials on setting this up or can some provide me with easy instructions. |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-06-21 : 10:14:19
|
| Well, what's the plan...I like the full replace method...depending on the volume....You could just TRUNCAT the table and BULK INSERT The data using a scheduled stored procedure...Or if you want to do true updates, you'd need to figure out what's new, old or changed...Like:http://weblogs.sqlteam.com/brettk/archive/2004/04/23/1281.aspxBrett8-) |
 |
|
|
|
|
|
Data Driven Query Task?