CODEWITHSUNDEEP
sql-serverssis
Vishal
Vishal

Reputation: 13

Issue in deployment of SSIS package?

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

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)

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

Upvotes: 0

Views: 425

Answers (1)

JoshLuedeman
JoshLuedeman

Reputation: 73

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.

  • Do you have a licensed copy of Task Factory on the server that you are trying to deploy too?
  • Did you assign an ADO .NET connection manager properly in the Upsert Destination when you created the package?

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 [email protected].

Upvotes: 1

Related Questions