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 |
|
Van
Constraint Violating Yak Guru
462 Posts |
 Posted - 2008-10-09 : 16:37:59
|
| When you create a DTS package and then right click it to schedule it, it creates a job for you with dtsexec calling the guid. If you then make changes to the DTS package will you have to reschedule the DTS package and delete the old schedule since the new version gets a new guid? I'm pretty sure you will but not totally certain. Thanks. |
|
|
Van
Constraint Violating Yak Guru
462 Posts |
Posted - 2008-10-09 : 16:55:39
|
| I found this bit of info:The DTS Designer in Enterprise Manager creates a new version GUID when you modify the package, but the Package GUID remains the same. When the Wizards schedule a DTS package for you they use the Package GUID not the version GUID.Can anyone verify whether this is correct? I've been asked the question and only have SQL 2005 on my work pc right now and can't test it out. Thanks. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Van
Constraint Violating Yak Guru
462 Posts |
Posted - 2008-10-10 : 15:00:56
|
| Same here... |
|
|
|
|
|
|
Question about scheduling DTS packages