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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-10-28 : 08:01:04
|
| Chris writes "Is there a way to rename a DTS package using T-SQL?Renaming with EM means that you have to re-schedule any jobs and it's a real pain. I have tried updating msdb.dbo.sysdtspackages table but this just seems to break any jobs running from that DTS?Any help much appreciated!Mr C" |
|
|
Other1
Starting Member
1 Post |
Posted - 2005-11-02 : 10:43:29
|
| Chris,Based on this thread it seems impossible.[url]http://groups.google.com/group/microsoft.public.sqlserver.dts/browse_thread/thread/bfb77fc13b3be517/38064a30612ac3c9[/url] |
 |
|
|
|
|
|
How to rename a DTS package (non EM)