Re: DTS Packages Not Saving Changes


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.developersdex.com ***
.

Relevant Pages

  • Re: Existence of Package.
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... SysDtsPackages but this needs a permission on msdb. ... before trying to load the Package. ...
    (microsoft.public.sqlserver.dts)
  • Re: Saving SSIS Packages
    ... I tried using the import wizard, importing a file based package and migrating ... Is DTC required for importing into msdb? ... When using the import wizard in SQL Server Management Studio, ... Package, IDTSEvents90 pEvents, String ServerName, String ServerUserName, ...
    (microsoft.public.sqlserver.dts)
  • Re: How do I grant execute/edit for a DTS package?
    ... If you choose Structured Storage File, it will ask you for a File Name ... contents of the package rather than having one person with rights. ... If the file already exists in SQL Server (in the msdb database), simply edit ...
    (microsoft.public.sqlserver.dts)
  • Re: Local DTS Packages Backup?-Thanks
    ... > SQL Server then backing up msdb will do it for you. ... >> How do you reliably backup local DTS packages on a server? ... >> I know you can save each package separately as a package or VB file ...
    (microsoft.public.sqlserver.dts)
  • Re: SQL 2005, DTS, problems, problems, problems, etc..
    ... You must take the package in and out of BIDS to make changes but this could be as simple as deploying from the previous project. ... Like in SQL ... list of packages under the File System or MSDB, ... "Allan Mitchell" wrote: ...
    (microsoft.public.sqlserver.dts)