SSIS (SQL Server Integration Service) support Database

SQL Server

安裝SQL Server預設會自動安裝Driver

或自行下載安裝

Download ODBC Driver for SQL Server 

https://docs.microsoft.com/en-us/sql/connect/odbc/download-odbc-driver-for-sql-server?view=sql-server-ver15

Oracle

建議使用Oracle官方Driver

安裝Oracle Client 32bit for Visual Studio/SSMS

安裝Oracle Client 64bit for SQL Server Instance(Linked Server to Oracle)

Microsoft OLE DB Provider for Oracle (MSDAORA) for 64 bit?

https://blog.sqlauthority.com/2016/12/17/sql-server-download-microsoft-ole-db-provider-oracle-msdaora-64-bit/

1. MSDAORA is short form for “Microsoft OLE DB Provider for Oracle”.
2. MSDAORA is driver provided by Microsoft to connect to Oracle database server.
3. There is no 64-bit version provided by Microsoft for MSDAORA. Its only available for 32 bit.
4. MSDAORA is no longer supported by current versions of Oracle. It was last updated for Oracle 9, and is no longer being updated.
5. For 64 bit, we need to download and use the Oracle client and the provider from their site for connecting with SQL. Oracle has a 64-bit version that is usable for us.
6. Oracle is a provider which is supported by Oracle.

MySQL

Connect to a MySQL Data Source (SQL Server Import and Export Wizard)

https://docs.microsoft.com/en-us/sql/integration-services/import-export-data/connect-to-a-mysql-data-source-sql-server-import-and-export-wizard?view=sql-server-ver15

Get the MySQL connectors

Download the providers and drivers described in this topic from the MySQL Connectors page.

MariaDB

MariaDB Connectors

https://mariadb.com/downloads/#connectors

PostgreSQL

Connect to a PostgreSQL Data Source (SQL Server Import and Export Wizard)

https://docs.microsoft.com/en-us/sql/integration-services/import-export-data/connect-to-a-postgresql-data-source-sql-server-import-and-export-wizard?view=sql-server-ver15

Get the PostgreSQL ODBC driver

Install the ODBC driver with Stack Builder

Run Stack Builder to add the PostgreSQL ODBC driver (psqlODBC) to your installation of PostgreSQL.

Install PostgreSQL ODBC with Stack Builder

Or, download the latest ODBC driver

Or, download the Windows installer for the latest version of the PostgreSQL ODBC driver (psqlODBC) directly from this FTP site - https://www.postgresql.org/ftp/odbc/versions/msi/. Extract the files from the .zip file and run the .msi file.

Sybase

Sybase ASE/Sybase IQ

SAP SQL Anywhere Database Client Download

https://wiki.scn.sap.com/wiki/display/SQLANY/SAP+SQL+Anywhere+Database+Client+Download

Users Guide

Adaptive Server® Enterprise

OLE DB Provider by Sybase 

15.7

http://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc00075.1570/pdf/oledb.pdf

Connecting to SAP ASE (SybaseToSQL)

https://docs.microsoft.com/en-us/sql/ssma/sybase/connecting-to-sybase-ase-sybasetosql?view=sql-server-ver15

• Import and Export from SQL Server to Sybase DB using SSIS
• SSIS with Sybase Connectors
• connecting to Sybase from Sqlserver SSIS
• Extracting data from Sybase SQL Anywhere using SSIS through ODBC
• Powerful SAP Sybase ADO.NET driver

DB2

IBM Data Server Driver Package (DS Driver)

設定ODBC Data Source選擇IBM DB2 ODBC DRIVER -IBMDBCLI

10.5的32位元版本安裝檔檔名：ibm_data_server_driver_package_win32_v10.5.exe

10.5的64位元版本安裝檔檔名：ibm_data_server_driver_package_win64_v10.5.exe

或用

Microsoft OLE DB Provider for DB2 Version 6.0

https://www.microsoft.com/en-us/download/details.aspx?id=100917

Installing Data Provider Version 6.0

https://docs.microsoft.com/en-us/host-integration-server/db2oledbv/installing-data-provider-version-6-0

Creating a linked server to DB2 using Microsoft OLE DB provider for DB2

https://support.microsoft.com/en-us/help/222937/creating-a-linked-server-to-db2-using-microsoft-ole-db-provider-for-db