SSIS errors
Posted: Fri 06 Apr 2018 14:26
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.
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.