question

GaryFurash avatar image
0 Votes"
GaryFurash asked GaryFurash commented

SSIS Fails if Run in x64 in Visual Studio

Effect: a 1 step package with a simple variable assignment fails with (below) if run in 64 bit mode from within visual studio (works w/ 64 bit turned off)

*Failed to start project (Microsoft Visual Studio)


Library not registered. (Exception from HRESULT: 0x8002801D (TYPE_E_LIBNOTREGISTERED)) (Microsoft.SqlServer.DTSRuntimeWrap)*

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

Failed to start project (Microsoft Visual Studio)

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

Library not registered. (Exception from HRESULT: 0x8002801D (TYPE_E_LIBNOTREGISTERED)) (Microsoft.SqlServer.DTSRuntimeWrap)


Program Location:

at Microsoft.DataTransformationServices.Project.DataTransformationsPackageDebugger.LaunchVsDebugger(Boolean isRemoteTest, IVsDebugger iVsDebugger, DataTransformationsProjectConfigurationOptions options)
at Microsoft.DataTransformationServices.Project.DataTransformationsPackageDebugger.ValidateAndRunDebugger(Int32 flags, IOutputWindow outputWindow, DataTransformationsProjectConfigurationOptions options)
at Microsoft.DataTransformationServices.Project.DataTransformationsProjectDebugger.LaunchDtsPackage(Int32 launchOptions, ProjectItem startupProjItem, DataTransformationsProjectConfigurationOptions options)
at Microsoft.DataTransformationServices.Project.DataTransformationsProjectDebugger.LaunchActivePackage(Int32 launchOptions)
at Microsoft.DataTransformationServices.Project.DataTransformationsProjectDebugger.LaunchDtsPackage(Int32 launchOptions, DataTransformationsProjectConfigurationOptions options)
at Microsoft.DataTransformationServices.Project.DataTransformationsProjectDebugger.Launch(Int32 launchOptions, DataTransformationsProjectConfigurationOptions options)

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

Library not registered. (Exception from HRESULT: 0x8002801D (TYPE_E_LIBNOTREGISTERED)) (Microsoft.SqlServer.DTSRuntimeWrap)


Program Location:

at Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSApplication100.get_ComponentStorePath()
at Microsoft.SqlServer.Dts.Runtime.Application..ctor(IDTSApplication100 app)



Tested Configurations;
VS: Visual Studio Community (Latest); Visual Studio Enterprise (Latest), SQL Server Data tools Installed
SSIS Projects from Marketplace (Latest)
OS: Windows 10 Professional



sql-server-integration-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

ZoeHui-MSFT avatar image
0 Votes"
ZoeHui-MSFT answered GaryFurash commented

Hi @GaryFurash,

I did some online research, here is a detailed blog described the error0x8002801D.

You may take a carefully reference to see if the resolution is helpful.

http://thewinwiki.org/wiki/wiki.php?kw=0x8002801d%20Ssis#4

Regards,

Zoe


If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

HI Zoe. Thanks for looking into this.

I'm not sure that's a real/safe site. The link is blocked as a malware site, and the explanation doesn't say anything other than "this is a hexidecimal number" which sounds fake. This seems like generic text generated by a bot or something.

0 Votes 0 ·