Solved

Failed SSIS SQL JOB

Posted on 2014-12-23
4
729 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
  • 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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
T-SQL 10 36
SharePoint 2013/ SQL 2014 - content database backup and restore from Prod to Dev 10 39
Nested Case statement 4 39
query linked sql table field from access 4 27
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
I have a large data set and a SSIS package. How can I load this file in multi threading?
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

820 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