PostreSql Source error
Posted: Thu 19 Apr 2018 16:06
Hi,
firstly I want to describe my errormessage and what I already did.
These are my error messages, when I execute the IS Package via Job scheduler.
When I execute the package from the visual studio, it runs successfully.
So I have deployed the project to our Integration Service Catalog and setup identical connections.
Then this message above occurs.
At the beginning I thought we have problems with the different Versions installed and referenced in GAC.
so I uninstalled the Versions on our development server and reinstalled it.
(to be honest there were also different versions installed)
However the error still exists and I'm at a loss.
Thanks in advance
and best regards
Steffen
firstly I want to describe my errormessage and what I already did.
Code: Select all
4/19/2018 4:31:48 PM
DFT SA PostgressCredit:Error: Devart PostgreSql Source failed the pre-execute phase and returned error code 0x80004002.
4/19/2018 4:31:48 PM
DFT SA PostgressCredit:Error: System.InvalidCastException: Unable to cast object of type 'Devart.Data.PostgreSql.bp' to type 'Devart.Data.PostgreSql.cq'.
at Devart.SSIS.PostgreSql.b.a(DbConnection A_0)
at Devart.SSIS.Common.SourceComponentBase.PreExecute()
at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPreExecute(IDTSManagedComponentWrapper100 wrapper)
When I execute the package from the visual studio, it runs successfully.
So I have deployed the project to our Integration Service Catalog and setup identical connections.
Then this message above occurs.
At the beginning I thought we have problems with the different Versions installed and referenced in GAC.
so I uninstalled the Versions on our development server and reinstalled it.
(to be honest there were also different versions installed)
However the error still exists and I'm at a loss.
Thanks in advance
and best regards
Steffen