I was told that we will be extracting data from Oracle database and loading into SQL Server Database. I will be developing packages on the Remote Server where SQL Server is installed. I mean I wont be developing anything on my local machine.
This is the first time I will be writing a package to extract data from Oracle database and my knowledge on Oracle is zero.
Could someone list out what all I need to do to extract data from Oracle database ? Server that I will be working is new and nothing is installed on that except the SQL Server 2008.
View Complete Post