Re: Saving SSIS Packages

Hello Dave,

So I can try to replicate your issue could you tell me how you are trying to save the package to MSDB (on 2K5 right?) This way i can at least mimic what you are doing.

Allan

I have db admin privilages on the server as well as msdb database.

"Allan Mitchell" wrote:

Hello Dave,

Is it possible that you do not have permission to save back the
package to MSDB on the SQL Server?

Allan

I am trying to save a SSIS package in SQL2005 to the database and it
keeps failing. I am getting the message:

Save to SQL Server Failed. No description found.

I can save it to a file without any issues. Any help would be
appreciated.



.

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: 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. ...
    (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)