Re: Saving SSIS Packages

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: Dts execution and the public role
    ... A DENY overrules the allow. ... When a permission is denied from a SQL Server user or Windows NT user ... If a permission is denied from a SQL Server role or a Windows NT ... > 3.- I assign permissions in the msdb DB to this user, ...
    (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)
  • Re: Can you use osql in DTS?
    ... This sounds simple enough to do in a single package. ... ActiveX Script task to build the date and time strings to populate the ... Data Pump task that executes a proc that populates a table and then ... Columnist, SQL Server Professional ...
    (microsoft.public.sqlserver.dts)