Is it possible to connect to Oracle 9i data source in SSIS? We're doing a migration from Oracle 9i to SQL Server 2008. So I'm thinking of a way to move the data from Oracle and I thought about SSIS. I'm new to this Microsoft's technology and I would like to know whether it's possible to specify Oracle 9i as a data source, and do I need any further installations in case it's possible ?
You can connect to Oracle from SSIS. You have to install Oracle client on your development and also on your production environments. After doing proper tnsnames configurations you can use odbc source or ado.net source.