Failed SSIS SQL JOB

barkome
barkome used Ask the Experts™
on
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.PipelineHost, Version=12.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'..  End Error

 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-4D327B9E785D} failed to initialize due to error 0x80131600 "".  End Error  Error: 2014-12-24 07:22:20.14     Code: 0xC0048021     Source: Data Flow Task Data Flow Task (source_table [386])     Description: The component is missing, not registered, not upgradeable, or missing required interfaces. The contact information for this component is "Oracle Source;Microsoft Connector for Oracle by Attunity; Attunity Ltd.; All Rights Reserved; http://www.attunity.com;4".  End Error

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?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2013
Awarded 2012

Commented:
Hi,
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

Author

Commented:
Same thing, with the 64-Bit version..still no joy
Commented:
Attunity Connectors not compatible with SQL 2014, had to do away with it and use OLEDB Data Source component within SSIS

Author

Commented:
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

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial