Re: Saving SSIS Packages

I tried using the import wizard, importing a file based package and migrating
a existing 2000 package. Is DTC required for importing into msdb? It seems
that I can get this to work on a server machine, but not my desktop. DTC is
the only thing so far I can find that is different.

This is on SQL2005.



When using the import wizard in SQL Server Management Studio, I get the
following error:

Save to SQL Server failed.

No description found (SQL Server Import and Export Wizard)

===================================

No description found

------------------------------
Program Location:

at
Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass.SaveToSQLServer(IDTSPackage90
Package, IDTSEvents90 pEvents, String ServerName, String ServerUserName,
String ServerPassword)
at Microsoft.SqlServer.Dts.DtsWizard.Execute.DoFileSaveStep(Exception& ex)



when importing a file package into the msdb, I get:

===================================

Invalid access to memory location. (Exception from HRESULT: 0x800703E6)
(Microsoft.SqlServer.ManagedDTS)

------------------------------
Program Location:

at Microsoft.SqlServer.Dts.Runtime.Application.SaveToDtsServer(Package
pPackage, IDTSEvents pEvents, String sPackagePath, String sServerName)
at
Microsoft.SqlServer.Dts.ObjectExplorerUI.ImportPackageAsAction.ImportPackage(ImportPackageAsForm dlg)


"Allan Mitchell" wrote:

> 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: Import and Schedule DTS on MSDE
    ... You can also open a package on the originating server and save as file, copy file, open file on dest ... server and save to msdb. ...
    (microsoft.public.sqlserver.tools)
  • Re: Error:EXECUTE permission denied on sp_add_dtspackage, database msdb, owner dbo
    ... remote server where I did not have access on msdb database.I changed ... the destination to save in the local server. ... I am trying to schedule a DTS package which imports data from a remote ... EXECUTE permission denied on sp_add_dtspackage, database 'msdb', owner ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS packages in SQL 2000 slow to open
    ... Are there many versions of the package in MSDB? ... Now try to open this package on the now remote server which was ... This way if it opens quickly you can say ... Also all the msdb tables open up quickly in the remote EM. ...
    (microsoft.public.sqlserver.dts)
  • TSLSA-2007-0007 - multi
    ... Affected versions: Trustix Secure Linux 2.2 ... The mod_php module enables the Apache web server to ... The postgresql package includes the client programs and libraries ... SECURITY Fix: Fetchmail does not properly enforce TLS and may ...
    (Bugtraq)
  • Re: remotely call a DTS
    ... Allan Mitchell wrote: ... Denied on something inside the package. ... This worked when I was logged into the server and ran it from my ... but the DTS blows up. ...
    (microsoft.public.sqlserver.dts)