|
Home > Archive > MS SQL Server DTS > September 2005 > DTS Packages Not Saving Changes
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
DTS Packages Not Saving Changes
|
|
|
|
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.droptable.com ***
| |
| Allan Mitchell 2005-09-19, 8:24 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
"SJM" <nospam@devdex.com> wrote in message
news:OrtkmrSvFHA.3740@TK2MSFTNGP14.phx.gbl:
> 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.droptable.com ***
| |
|
|
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.
*** Sent via Developersdex http://www.droptable.com ***
| |
| Allan Mitchell 2005-09-20, 8:23 pm |
| So you are not saving it? OK try doing SAVE AS instead of SAVE and see
if you can save that package.
"SJM" <nospam@devdex.com> wrote in message
news:u3nspmdvFHA.2656@TK2MSFTNGP10.phx.gbl:
> 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.
>
>
>
>
> *** Sent via Developersdex http://www.droptable.com ***
| |
|
|
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.
*** Sent via Developersdex http://www.droptable.com ***
|
|
|
|
|