Sunday, February 19, 2012

Error Importing SSIS Package

I can't import a package from the SSIS to the file system of my SQL Server Management Studio. Every time i've tried the following message appears. What should i do to correct this problem? Any ideas?

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

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)

Similar problem here:

I cannot store DTSX-Packages from local filesystem on the ISS-MSDB, if I try I get the same errormessage as you.

Regards,

Jan

|||

I had the same problem and the fix was to run

Regsvr32 msxml3.dll
Regsvr32 msxml6.dll

//Niclas

|||Thanks Niclas. This worked for me too.

No comments:

Post a Comment