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.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?
barkomeAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rainer JeschorCommented:
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
0
barkomeAuthor Commented:
Same thing, with the 64-Bit version..still no joy
0
barkomeAuthor Commented:
Attunity Connectors not compatible with SQL 2014, had to do away with it and use OLEDB Data Source component within SSIS
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
barkomeAuthor 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
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.