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)
May 17th, 2006 6:38pm
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
Free Windows Admin Tool Kit Click here and download it now
July 12th, 2006 3:38pm
I had the same problem and the fix was to run
Regsvr32 msxml3.dllRegsvr32 msxml6.dll
//Niclas
September 21st, 2006 9:08am
Thanks Niclas. This worked for me too.
Free Windows Admin Tool Kit Click here and download it now
October 20th, 2006 4:22pm
Anything worked for me, but i believe tha the instalation of my sql was corrupted. So after i've reinstaled it's working fine. Thanks for all the help.And sorry for taking so long to end this thread.
January 22nd, 2008 4:42pm
Nice Fix
Thks a lot
Mz
Free Windows Admin Tool Kit Click here and download it now
July 13th, 2010 11:34pm
Niclas fix my problem... thanks
July 27th, 2010 6:40pm
Niclas
That worked for me - saved me a lot of time
Thanks!
Joe
Free Windows Admin Tool Kit Click here and download it now
September 3rd, 2010 5:03pm
Thanks for the solution, it worked for me too.
Harsha
March 14th, 2011 12:02pm