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.

Hello Dave,

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

Allan

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

"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 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.Applicatio nClass.SaveToSQLServer(IDTSPackage90
Package, IDTSEvents90 pEvents, String ServerName, String ServerUserName,
String ServerPassword)
at Microsoft.SqlServer.Dts.DtsWizard.Execute.DoFileSa veStep(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.SaveTo DtsServer(Package
pPackage, IDTSEvents pEvents, String sPackagePath, String sServerName)
at
Microsoft.SqlServer.Dts.ObjectExplorerUI.ImportPac kageAsAction.ImportPackage(ImportPackageAsForm dlg)


"Allan Mitchell" wrote: