2012年12月5日 星期三

SSIS Oracle Source and Destination

SQL Server Integration Service可以透過內建的OLE DB Source連線到Oracle匯出資料,但無法寫入資料到Oracle,Attunity公司針對這個功能提供了SSIS的連結Source,並且聽說資料傳送效率非常好,本人沒有測試過效能,有興趣的朋友可以試試。

Microsoft® Connectors v1.2 for Oracle and Teradata
for SQL Server 2008 Integration Service

Microsoft Connectors v2.0 for Oracle and Teradata
For SQL Server 2012 Integration Service

Installation
In summary, if you want both to develop and to run SSIS packages on a 64-bit computer:
1.Install the Attunity Oracle 64 bit connector.(the 64 bit connector installs both 32-bit and 64-bit versions)
2.Install the Oracle 11G 64 Bit client.
3.Install the Oracle 11G 32 Bit client.
4.Restart the computer after the Oracle installations are complete.
5.You should be able to develop and run SSIS packages.


Install Microsoft® Connectors v1.2 for Oracle with Error message cannot retistry AttunitySSISOraAdapters.dll and the AttunitySSISOraConnections.dll
http://www.attunity.com/forums/microsoft-ssis-connectors-attunity/installation-issues-1735.html

[solution]
Download: Visual C++ 2008 SP1 Redistributable Package (x64) - Microsoft Download Center - Confirmation
或是直接安裝Visual Studio 2008 SP1
http://www.microsoft.com/en-us/download/details.aspx?id=13276


========================================================================
Microsoft® Connectors v1.2 for Oracle and Teradata
http://www.microsoft.com/en-us/download/details.aspx?id=29284

Download the SSIS Connectors Version 1.2 for Oracle and Teradata that provide additional value for SQL Server Integration Services (SSIS).

Quick details

Version:1.2Date published:7/9/2012
Language:English

Files in this download

The links in this section correspond to files available for this download. Download the files appropriate for you.
File nameSize
AttunitySSISOraAdaptersSetup.msi2.1 MBDownload
AttunitySSISOraAdaptersSetupX64.msi3.8 MBDownload
AttunitySSISTeraAdaptersSetup.msi2.7 MBDownload
AttunitySSISTeraAdaptersSetupX64.msi4.9 MBDownload


========================================================================
Microsoft Connectors v2.0 for Oracle and Teradata
http://www.microsoft.com/en-us/download/details.aspx?id=29283

Download the SSIS Connectors v2.0 for Oracle and Teradata that provide additional value for SQL Server Integration Services (SSIS) 2012.

Quick details

Version:2.0Date published:4/3/2012
Language:English

Files in this download

The links in this section correspond to files available for this download. Download the files appropriate for you.
File nameSize
AttunitySSISOraAdaptersSetup.msi2.3 MBDownload
AttunitySSISOraAdaptersSetupX64.msi3.9 MBDownload
AttunitySSISTeraAdaptersSetup.msi2.8 MBDownload
AttunitySSISTeraAdaptersSetupX64.msi5.0 MBDownload
參考
Microsoft Connectors v2.0 for Oracle and Teradata – Now Available
http://blogs.msdn.com/b/mattm/archive/2012/04/04/microsoft-connectors-v2-0-for-oracle-and-teradata-now-available.aspx


Using the Microsoft Connector for Oracle by Attunity with SQL Server 2008 Integration Services

沒有留言: