问题加载SSIS自定义连接管理器/类型

时间:2022-06-01 16:57:44

I'm currently trying to build a custom connection manager and custom data flow source for a proprietary system at work, and I'm running into an odd problem when I attempt to execute a task containing my custom manager (from BIDS, DTEXEC, or the agent)

我目前正在试图建立在工作中的专有系统的自定义连接管理器和自定义数据流源,和我运行到一个奇怪的问题,当我试图执行包含我的自定义管理器(出价的,DTEXEC任务,或中介)

Error: 0xC0014005 at : The connection type "AF" specified for connection manager "AFConnection" is not recognized as a valid connection manager type. This error is returned when an attempt is made to create a connection manager for an unknown connection type. Check the spelling in the connection type name.

错误:0xC0014005 at:为连接管理器指定的连接类型“AF”“AFConnection”未被识别为有效的连接管理器类型。尝试为未知连接类型创建连接管理器时,将返回此错误。检查连接类型名称中的拼写。

Error: 0xC0010018 at : Error loading value "<DTS:ConnectionManager xmlns:DTS="www.microsoft.com/SqlServer/Dts"><DTS:Property DTS:Name="DelayValidation">0</DTS:Property><DTS:Property DTS:Name="ObjectName">AFConnection</DTS:Property><DTS:Property DTS:Name="DTSID">{43304F2E-0C3F-4C00-9221-BD88C50EDDFC}" from node "DTS:ConnectionManager".

错误:0xC0010018 at:加载值错误“ 0 AFConnection {43304F2E-0C3F-4C00-9221-BD88C50EDDFC}“来自节点”DTS:ConnectionManager“。 属性dts:名称=“dtsid”> 属性dts:名称=”delayvalidation“>

I have the relevant DLLs in the GAC as well as the \90\DTS\Connections folder. All other connection managers work fine.

我在GAC以及\ 90 \ DTS \ Connections文件夹中有相关的DLL。所有其他连接管理器工作正常。

Here is the connection manager boilerplate:

这是连接管理器样板:

    [DtsConnection(ConnectionType="AF", Description="Connection manager for AF2", DisplayName="AF Connection"
        , UITypeName = "AnalysisFrameworkCustomTask.AFConnectionManagerUI,AnalysisFrameworkCustomTask,Version=1.0.0.0,Culture=neutral,PublicKeyToken=e11db2e10378dc29")]
    public class AFConnectionManager : ConnectionManagerBase
    {    

        #region Overrides

        public override DTSExecResult Validate(IDTSInfoEvents infoEvents)
        {
            // Code omitted that determines success or failure

            return DTSExecResult.Success;
        }

        public override object AcquireConnection(object txn)
        {
            // Code ommitted to return new connection; works fine when debugged
            // in the development environment
        }

        public override void ReleaseConnection(object connection)
        {
            // Code ommitted to release connection; works fine when debugged
            // in the development environment
        }

        #endregion
    }

Has anyone seen this before and have any idea how to move forward?

有没有人见过这个,有任何想法如何前进?

1 个解决方案

#1


Try restarting the SSIS service.

尝试重新启动SSIS服务。

#1


Try restarting the SSIS service.

尝试重新启动SSIS服务。