SSIS errors

Discussion of issues, suggestions and bugs of Devart SSIS Data Flow Components, our product line for building SSIS-based ETL solutions, performing data access to popular cloud applications and databases.
Post Reply
sviking
Posts: 5
Joined: Wed 28 Mar 2018 16:06

SSIS errors

Post by sviking » 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.

sviking
Posts: 5
Joined: Wed 28 Mar 2018 16:06

Re: SSIS errors

Post by sviking » Mon 09 Apr 2018 11:21

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
Site Admin
Posts: 8425
Joined: Thu 14 Aug 2008 12:44

Re: SSIS errors

Post by Shalex » Mon 09 Apr 2018 14:08

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
Posts: 5
Joined: Wed 28 Mar 2018 16:06

Re: SSIS errors

Post by sviking » Tue 10 Apr 2018 10:03

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
Site Admin
Posts: 8425
Joined: Thu 14 Aug 2008 12:44

Re: SSIS errors

Post by Shalex » Tue 10 Apr 2018 16:18

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?

Post Reply