Failed SSIS SQL JOB
I have a package developed with SQL Data Tools using Attunity Data Connector for Oracle (Version 2.0).
I have a SSIS proxy account, that is used to execute the ssis job, where the package is saved on the local file system of the server. The package executes flawlessly with no problems from the VS2012 IDE.
But, when I manual start the job to test if it will execute within a scheduled job it fails. Looking at the job history, the following extract from the error message appears:
Message
Executed as user: servername\Administrator. ... for 64-bit Copyright (C) Microsoft Corporation. All rights reserved. Started: 7:22:17 AM Error: 2014-12-24 07:22:20.14 Code: 0xC00490F7 Source: Data Flow Task Data Flow Task (source_table [386]) Description: The managed pipeline component "AttunitySSISOraSrc.5" could not be loaded. The exception was: Could not load type 'AttunitySSISOraSrc.5' from assembly 'Microsoft.SqlServer.Pipel
End Error Error: 2014-12-24 07:22:20.14 Code: 0xC0047076 Source: Data Flow Task Data Flow Task (SSIS.Pipeline) Description: Component source_table, clsid {33D831DE-5DCF-48F0-B431-4
Error: 2014-12-24 07:22:20.14 Code: 0xC004801F Source: Data Flow Task Data Flow Task (SSIS.Pipeline) Description: The component metadata for "source_table" could not be upgraded to the newer version of the component. The PerformUpgrade method failed. End Error
Can anyone help?
I have a SSIS proxy account, that is used to execute the ssis job, where the package is saved on the local file system of the server. The package executes flawlessly with no problems from the VS2012 IDE.
But, when I manual start the job to test if it will execute within a scheduled job it fails. Looking at the job history, the following extract from the error message appears:
Message
Executed as user: servername\Administrator. ... for 64-bit Copyright (C) Microsoft Corporation. All rights reserved. Started: 7:22:17 AM Error: 2014-12-24 07:22:20.14 Code: 0xC00490F7 Source: Data Flow Task Data Flow Task (source_table [386]) Description: The managed pipeline component "AttunitySSISOraSrc.5" could not be loaded. The exception was: Could not load type 'AttunitySSISOraSrc.5' from assembly 'Microsoft.SqlServer.Pipel
End Error Error: 2014-12-24 07:22:20.14 Code: 0xC0047076 Source: Data Flow Task Data Flow Task (SSIS.Pipeline) Description: Component source_table, clsid {33D831DE-5DCF-48F0-B431-4
Error: 2014-12-24 07:22:20.14 Code: 0xC004801F Source: Data Flow Task Data Flow Task (SSIS.Pipeline) Description: The component metadata for "source_table" could not be upgraded to the newer version of the component. The PerformUpgrade method failed. End Error
Can anyone help?
ASKER
Same thing, with the 64-Bit version..still no joy
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Rebuilt the ETL package from scratch, but this time not with the Attunity Data Connector for Oracle v2.0 as it is not compatible with SQL Server 2014
have you installed the x64 bit components as well?
The easiest thing would be to set the flag on the SSIS job to run the job as 32-bit (x86). The SQL Data Tools environment runs as 32 bit application - regardless of the OS version - whereas the job runs in 64-bit mode by default on x64 systems - and this will load a completely different set of components.
Second option would be to install the 64-bit Attunity components.
HTH and merry christmas
Rainer