部署SSIS包的问题？

I am getting the below error while deploying the SSIS package on the server

我在服务器上部署SSIS包时遇到以下错误

Error Message: Load Account:Error: System.ArgumentException: Value does not fall within the expected range. at Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSConnectionManager100.AcquireConnection(Object pTransaction) at PW.TaskFactory.BasePipelineComponent.GetConnectionFromConnectionManager(Object tx, ConnectionManager manager, Boolean checkSqlVersion) at PW.TaskFactory.BasePipelineComponent.GetConnection(Object tx, String connectionNameProperty, Boolean checkSqlVersion) at PW.TaskFactory.UpsertDestinationTask.UpsertDestination.AcquireConnections(Object transaction) at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostAcquireConnections(IDTSManagedComponentWrapper100 wrapper, Object transaction)

错误消息:加载帐户:错误:System.ArgumentException:值不在预期范围内。在PW.TaskFactory.BaseFipeory.BaseFipeory.BaseFipeory.BetPipelineComponent.GetConnection(Object tx,String connectionNameProperty)的PW.TaskFactory.BasePipelineComponent.GetConnectionFromConnectionManager(Object tx,ConnectionManager manager,Boolean checkSqlVersion)上的Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSConnectionManager100.AcquireConnection(Object pTransaction) ,Boolean checkSqlVersion)at Microsoft .SqlServer.Dts.Pipeline.ManagedComponentHost.HostAcquireConnections(IDTSManagedComponentWrapper100 wrapper,Object transaction)中的PW.TaskFactory.UpsertDestinationTask.UpsertDestination.AcquireConnections(Object transaction)

Is there any particular deployment setting which is giving this error?

是否有任何特定的部署设置会出现此错误?

1 个解决方案

#1

It appears that you are running Pragmatic Works' Task Factory component "Upsert Destination" in the package, and it is having a problem creating a connection. There are a couple questions I have.

您似乎在包中运行Pragmatic Works的任务工厂组件“Upsert Destination”,并且在创建连接时遇到问题。我有几个问题。

• Do you have a licensed copy of Task Factory on the server that you are trying to deploy too?

您是否在要尝试部署的服务器上拥有Task Factory的许可副本?

• Did you assign an ADO .NET connection manager properly in the Upsert Destination when you created the package?

在创建包时,您是否在Upsert目的地中正确分配了ADO .NET连接管理器?

If you are not sure, or are still having problems, I would reach out to Pragmatic Works technical support for help with the issue at [e-mail].

如果您不确定或仍有问题,我会联系Pragmatic Works技术支持以获取有关该问题的帮助,请访问[e-mail]。