Microsoft Connector For Oracle By Attunity For Ssis Derived

by

This white paper describes the procedures needed to configure Oracle database drivers for use in Microsoft BI services (SSIS. Oracle Driver configuration for SSIS, SSRS and SSAS in a 64-bit Environment. Includes configuration procedures for both the 64-bit and 32-bit versions of the Oracle Provider for OLEDB and the Microsoft Connector.

Viewed 954 times
For

I am using the Microsoft Connector for Oracle by Attunity with SQL Server 2010 Integration Services. Install the Microsoft Connector for Oracle by Attunity.SSIS Package connected succeed oracle connection manager editor.

  1. Microsoft Connector for Oracle by Attunity. Microsoft Connector Version 2.0 for Oracle by Attunity - The Oracle source and destination components are written to achieve optimal performance when loading data into Oracle or unloading data from Oracle in the context of Microsoft SSIS.
  2. I am using 'Oracle Destination' data flow destination using Microsoft Connector for Oracle by Attunity with SQL Server 2008 Integration Services. Looking for sample ETL package to extract data from SQL Sever Database and load into Oracle Database using SQL SERVER INTEGRATION SERVICES 2008. The requirement is for full load and incremental.

First of all create one database on sqlserver. Example (ordb Database).

Start->All Program->Click SQL Server Data Tools and then click New Project & Select the Integration Project click Ok Button.

Drag the Data flow Task from SSIS ToolBox in Control Flow. Select the data flow task and right click edit , open data flow.

In dataflow under Oracle Source drag the ssis toolbox and create new for connection manager: xx and choose the Data Access Code :Table Name& name of the table or view : Dar.xx.

Select Table od table on Oracle Source and od table totally three columns there (Id,Name,Xml). Once dataflow path connect with oledb destination xml column hidden and remaining two columns only there in preview.

Another xy Table one column there (Xml Column). In the oracle source created connection manager and selected xx table.

I will connect Dataflow path editor to another oledb destination in ssis toolbox. Once connect dataflow path editor and open oledb destination but (This Component has no available input columns) aler box shows.

How to fix the issue from ssis package

Tab Alleman
28.8k6 gold badges26 silver badges46 bronze badges
vinoth annamalaivinoth annamalai
Is this question similar to what you get asked at work? Learn more about asking and sharing private information with your coworkers using Stack Overflow for Teams.

Browse other questions tagged oraclessisattunity or ask your own question.

Active1 year, 11 months ago

I have no problem running an SSIS package from VS2015 on my dev machine transferring from Teradata 15 to SQLServer 2016 using Attunity 4.0 and all of the following from TTU 16.10.01:

  • ODBC Driver
  • OLEDB Access Module
  • .Net Data Provider
  • TPT Base

  • TPT Stream

    but when I deploy the package to the same SQLServer the execution fails with this error:

'Data Flow Task:Error: The version of Teradata Source - [source name] is not compatible with this version of the DataFlow.'

I have installed exactly the same Attunity & TTU drivers on the server.

Have I missed setting up something on the SQL Server?

Attunity Oracle Driver For Ssis

ItalloSanItalloSan

1 Answer

SSIS Connectors v5.0 for Oracle and Teradata supports only TPT API versions : 14.10; 15; 15.10You need to downgrade TTU to 15.10 or wait for Connector v6.0 release

Microsoft Connector For Oracle By Attunity For Ssis Derived System

badunbadun

Attunity Ssis Oracle

Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.

Download Ssis Attunity Connector

Not the answer you're looking for? Browse other questions tagged sql-serverssisteradatadataflowattunity or ask your own question.