SSIS errors

[sviking]

Hi,

We developed an SSIS solution using SSDT 2012 against SQL Server 2012, but because of the recent upgrade of SQL DB version from 2012 to 2016 we upgraded the package using SSDT 2015. Although we had issues with the upgraded packages, we could successfully fix all issues, deployed on a test box running 2016. All well until here.

Now we try to deploy the same solution which worked well in the test, into production, we get this error

Cannot find the connection manager with ID "{46E605D2-1DCA-4760-A6AF-AE2F1FC43F7A}" in the connection manager collection due to error code 0xC0010009. That connection manager is needed by "SRC - xxxx.Connections[Devart PostgreSql]" in the connection manager collection of "SRC - xxxx". Verify that a connection manager in the connection manager collection.

The DevArt SSIS dataflow component version installed in all environments is 1.7.672, and is a 64-bit edition running with SQL Server 2016 Enterprise Edition, 64-bit.

Please advise, and thanks in advance.

[sviking]

I was checking yet another post viewtopic.php?t=36112 which was reflecting same issue but under different situations.

However, I happen to check the property of that is set in the packages for the component we are using and this is what we have.

Code: Select all

  <property
                              dataType="System.String"
                              name="UserComponentTypeName">Devart.SSIS.PostgreSql.PgSqlSource, Devart.SSIS.PostgreSql.130, Version=1.0.0.0, Culture=neutral, PublicKeyToken=09af7300eec23701</property>
                          </properties> 

Any help is appreciated.

[Shalex]

1. Please right click your SSIS project in Solution Explorer of VS2015 > Properties > Configuration Properties > General and specify your value of TargetServerVersion.

2. Navigate to ... > Configuration Properties > Debugging and tell us your value of Run64BitRuntime.

[sviking]

1. Please right click your SSIS project in Solution Explorer of VS2015 > Properties > Configuration Properties > General and specify your value of TargetServerVersion.

>> The version specified is SQL Server 2016

2. Navigate to ... > Configuration Properties > Debugging and tell us your value of Run64BitRuntime.

>> Value of Run64BitRunTime is False

Please suggest, what further. I have raised a support ticket to address this.

[Shalex]

1. SQL Server 2016 64-bit is installed on your deployment workstation, isn't it? Please make sure that the following files are created by the Devart SSIS Data Flow Components for PostgreSQL installation:

* "C:\Program Files\Microsoft SQL Server\130\DTS\Connections\Devart.SSIS.PostgreSql.130.dll"
* "C:\Program Files\Microsoft SQL Server\130\DTS\PipelineComponents\Devart.SSIS.PostgreSql.130.dll"
* "C:\Windows\Microsoft.NET\assembly\GAC_MSIL\Devart.SSIS.PostgreSql.130\" (folder)

2. SQL Server Job is used for running SSIS package in the deployment environment, isn't it? Try turning off the "Use 32 bit runtime" option: https://stackoverflow.com/a/23867536/135566 . Does this help?