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 |
|
JimEdwards
Starting Member
6 Posts |
 Posted - 2006-05-23 : 12:48:54
|
This is probably a st00p1d n00b question, but here goes:I have a DTS package that I got from someone else, but it needs to be edited. It was set as a local package, but when I double-click it in Enterprise Manager and edit it, then save and quit, I can go right back in and changes are gone, as if it was never edited.Well, lo and behold, I got the bright idea to edit the package using Notepad, then bring the package back into Enterprise Manager. Now it says it can't do it because it's no longer a DTS Package. Fortunately, I have another unmodified copy, or I would have really thrown out the baby with the bathwater.  So my question is: What do I need to use to edit the package offline, then be able to bring it back into Enterprise Manager as a valid DTS Package? |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-05-23 : 16:19:17
|
| Do it n enterprise manager.Is the package saved as a file or to the server?When you edit it make sure you save it to the place you are re-opening it.Also make sure you are opening the latest version - all the history is held with the package as different versions.Save it as a different name then open it to make sure.==========================================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. |
 |
|
|
JimEdwards
Starting Member
6 Posts |
Posted - 2006-05-24 : 09:04:59
|
Thanks a bundle, nr!  Here's what worked:1. Remove the DTS from SQL Server.2. Open original package in Enterprise Manager and edit.3. Save package.4. Open package again and save to SQL Server.quote:
Originally posted by nr[Beer is not cold and it isn't fizzy.
Only to us Merkuns, I guess.  (Please send Boddington's) |
|
|
|
|
|
|
|
|
Making a DTS package edit stick