From day one SQL Server Integration Services has had the ability to access third-party databases via both ODBC and OleDB. However these are often much slower than the native interfaces exposed by the database.
To help remedy this third party vendors such as Attunity develop connectors that give SSIS developers direct access to the native interfaces. In a deal with Microsoft, they are giving away their SSIS connectors for Oracle and Teradata. These are available in both 32 and 64-bit versions from the Microsoft Download Center.
Oracle support includes 9.2.0.4 and later on x86, x64, and ia64. Teradata support is for versions 2R6.0, 2R6.1, 2R6.2 and 12.0 on x86 and x64.