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 |
|
itpetiks
Starting Member
6 Posts |
 Posted - 2006-05-10 : 17:55:14
|
| Hi Everyone, say i have a scheduled dts that copy a source table to a destination table. question is, i want to have a (1)step that will delete first. before the (2) step that will copy. example a simple query "delete from table1" how do i include this in a job's step?thanks in advanceDenz |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-05-10 : 19:01:12
|
| Just add another step to the job with the delete statement in it and set it to run first.Often people put the delete in the dts package before the copy.==========================================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. |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-05-10 : 22:47:15
|
| instead of a job step, do it in the dts, it is more convenient since you can modify the entire process in one package instead of going through both the job and package aside from being able to lock down the dts package from modificationif it's a job step, anyone who has the sql permission to do so will be able to modify it, in a package you need an owner password (if defined)then use workflow to sequence the tasks--------------------keeping it simple... |
|
|
|
|
|
|
How to add delete query in a JOB Step?