Solved

Failed SSIS SQL JOB

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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Here's a requirements document template for an integration project (also known as Extract-Transform-Load or ETL) based on my development experience as an SQL Server Information Services (SSIS) developer over the years.
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…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

895 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now