Re: DTS Packages Not Saving Changes

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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



"SJM" <nospam@xxxxxxxxxx> wrote in message news:OrtkmrSvFHA.3740@xxxxxxxxxxxxxxxxxxxx:

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.


*** Sent via Developersdex http://www.developersdex.com *** 

.

Relevant Pages

  • Re: SSIS package protection level
    ... You can't choose ServerStorage when saving to File System. ... deploy your package to SQL Server or change your ProtectionLevel to another ... Failed to apply package protection with error 0xC0014061 "The protection ...
    (microsoft.public.sqlserver.dts)
  • PowerPoint doubt.
    ... I have PowerPoint 2007 complete package. ... gives you all you can do, plus, when saving on an early version it tells you ... I have File Format converter. ...
    (microsoft.public.powerpoint)
  • Re: Finished the sewing for new great-nephew
    ... I printed that one along with several others I've been saving to make a "How to be a Grandpa" package for my brother at the shower today. ...
    (alt.sewing)
  • Re: DTS Takes forever to save
    ... WHILE the package is saving I also notice that mmc.exe is taking 97% of my CPU and the memory usage grows. ... I have activescript and other things in the package. ...
    (microsoft.public.sqlserver.dts)
  • tcllib package mimetype and non-file-data
    ... without saving it into a file for its real mime type. ... I found the tcllib package mimetype, but this package only allows to ...
    (comp.lang.tcl)