sql server dts: DTS Packages Not Saving Changes -- sql server dts

DTS Packages Not Saving Changes

SJM
9/19/2005 8:00:38 AM

sql server dts:

I am having a problem with DTS packages not saving changes. For example,
this morning, I spent fours hours changing VBScript code and other
things in a DTS package. I saved it multiple times. At 10:40AM I saved
the package to the server in DTS designer, closed enterprise manager and
logged off my workstation. At 11:00AM I logged back on, opened up
enterprise manager, and the package existed as it did at 7AM without any
of the new changes. This has happened several times over the past few
weeks. I have been saving the vbscript code in textfiles to deal with
this but I wish to know if anyone else is having this problem. Notably,
no error messages of any kind are received during this process. Any
comments or suggestions would be appreciated.

Re: DTS Packages Not Saving Changes

Allan Mitchell
9/19/2005 7:55:02 PM

The package should be being saved back with the changes. The only
reason I could see that it would not be is if you are opening a previous
version. Are you saving to SQL Server? Do you see rows in
msdb..sysdtspackages for the package you keep saving? Can you see when
they were added?

Are you sure you are saving the package to where you think you are
saving it?

If you right click on the package in EM and choose "Versions..." do you
see your versions?

Allan

[quoted text, click to view]

Re: DTS Packages Not Saving Changes

SJM
9/20/2005 4:51:38 AM

Hello Allan and thank you for your reply.

The package is being saved to SQL Server and newer saved versions do not
show up in msdb sys.dtspackages. In Enterprise Manager, the previous and
future versions do not show up. I have the PackageID for all the
versions that didn't save and I cannot locate any information in the
msdb tables for them. I am really stumped by this since I became aware
of it a couple weeks ago I have been really watching things and I have
not been able to figure it out.

Re: DTS Packages Not Saving Changes

SJM
9/20/2005 12:40:35 PM

Save as works and has worked fine as long as I change the package name.

This was an odd phenomenon, so I was hoping there was a KB article or
something and I just couldn't find it.

The save function doesn't seem to do anything sometimes and I cannot
determine what actions are causing this. It is intermittent.

Re: DTS Packages Not Saving Changes

Allan Mitchell
9/20/2005 7:15:55 PM

So you are not saving it? OK try doing SAVE AS instead of SAVE and see
if you can save that package.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server dts group.