Hi, I have not used Oracle before two days ago (not a fan yet), and I am trying to use SSIS to connect to a remote Oracle database with the aim of copying the data from the remote Oracle (11g) database to a local SQL Server 2008 database. For my remote connection I have a Connection Name, Username, Password, Hostname, Port, and an SID. I have not yet found anything regarding connecting to a remote Oracle database. Can anyone please help me out with this? Thanks

you can install ODP.NET ( Oracle Data Provider for .NET ) and then create a simple OLEDB Connection to the oracle database with provided connection details. settings are simple to do.http://www.rad.pasfu.com

You can use the built-in OLE DB provider for Oracle to connect to the Oracle DB with the OLE DB Source or with an Execute SQL Task. If you don't have an OLE DB provider yet, you can download one here: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=d9cb21fe-32e9-4d34-a381-6f9231d84f1eMCTS, MCITP - Please mark posts as answered where appropriate.