Solved

Failed SSIS SQL JOB

Posted on 2014-12-23
4
847 Views
Last Modified: 2016-02-15
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?
0
Comment
Question by:barkome
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 44

Expert Comment

by:Rainer Jeschor
ID: 40517181
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
 

Author Comment

by:barkome
ID: 40523378
Same thing, with the 64-Bit version..still no joy
0
 

Accepted Solution

by:
barkome earned 0 total points
ID: 40561455
Attunity Connectors not compatible with SQL 2014, had to do away with it and use OLEDB Data Source component within SSIS
0
 

Author Closing Comment

by:barkome
ID: 40568996
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

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

My client has a dictionary table. They're defining a list of standard naming convention. Now, they are requiring my team to provide us a mechanism how to match new incoming data with existing data in their system.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

717 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question