Package runs in Visual Studio, but not in SSIS
Posted: Tue 26 Feb 2019 10:03
Dear Forum.
I need assistance with a packge using DevArt PostgreSQL Data Flow Components.
The package runs without any issues in VS.
However when run in SQL Manager as SSIS package, or from Task Agent, it does not run, instead reports a missing component:
"Devart.SSIS.PostgreSql.PgSqlSource, Devart.SSIS.PostgreSql.140, Version=1.0.0.0, Culture=neutral, PublicKeyToken=09af7300eec23701" could not be loaded... file or assembly "Microsoft.SqlServer.DTSRuntimeWrap, Version=14.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" or a dependancy thereof not found...
System:
Microsoft SQL Server 2016 (SP1-CU6) (KB4037354) - 13.0.4457.0 (X64) Nov 8 2017 17:32:23 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on
Windows Server 2012 R2 Datacenter 6.3 <X64> (Build 9600: ) (Hypervisor)
Please assist.
- KaiRo
I need assistance with a packge using DevArt PostgreSQL Data Flow Components.
The package runs without any issues in VS.
However when run in SQL Manager as SSIS package, or from Task Agent, it does not run, instead reports a missing component:
"Devart.SSIS.PostgreSql.PgSqlSource, Devart.SSIS.PostgreSql.140, Version=1.0.0.0, Culture=neutral, PublicKeyToken=09af7300eec23701" could not be loaded... file or assembly "Microsoft.SqlServer.DTSRuntimeWrap, Version=14.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" or a dependancy thereof not found...
System:
Microsoft SQL Server 2016 (SP1-CU6) (KB4037354) - 13.0.4457.0 (X64) Nov 8 2017 17:32:23 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on
Windows Server 2012 R2 Datacenter 6.3 <X64> (Build 9600: ) (Hypervisor)
Please assist.
- KaiRo