February 11, 2012 at 3:48 pm
hi
i have to make package that get data from oracle,how to connect to oracle.plz explain me.
Is it using linkserver or something else.If not why we are using link server.
Thanks
February 12, 2012 at 3:24 am
OLE DB Source in SSIS:
http://msdn.microsoft.com/en-us/library/ms141696.aspx
Limitation:
The Microsoft OLE DB provider for Oracle does not support the Oracle data types BLOB, CLOB, NCLOB, BFILE, OR UROWID, and the OLE DB source cannot extract data from tables that contain columns with these data types.
February 12, 2012 at 7:57 am
Thanks Dev
February 12, 2012 at 11:41 pm
Also make sure you have the Oracle client installed and configured.
If any doubt, contact your Oracle administrator.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 13, 2012 at 9:01 am
A further note is that BIDs needs the 32bit Oracle client, if you are working on a 64bit server you may need to do dev. with the 32bit and 64bit for QA ; then a pure 64bit client implementation in production.
February 14, 2012 at 8:24 am
The full Oracle client is a monster, and server admins are sometimes reluctant about intalling it. If all you need is connectivity for a linked server connection or SSIS, then you can install the Oracle Instant Client, which basically involves copying a few MB of .DLL and other library files into a folder on the server and placing folder in the %PATH%.
http://www.oracle.com/technetwork/database/features/instant-client/index.html
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 14, 2012 at 11:21 am
I had a project which required getting a lot of data out of Oracle into SQL Server via SSIS. I investigated using the Oracle OLE DB connector, but I found that the Attunity Microsoft Connector for Oracle better met my needs. You can download it here for free from Microsoft.
Edit: Sorry, I'm using SSIS '08. I don't know if there is a corresponding version for '05.
February 14, 2012 at 12:55 pm
Eric M Russell (2/14/2012)
The full Oracle client is a monster, and server admins are sometimes reluctant about intalling it. If all you need is connectivity for a linked server connection or SSIS, then you can install the Oracle Instant Client, which basically involves copying a few MB of .DLL and other library files into a folder on the server and placing folder in the %PATH%.http://www.oracle.com/technetwork/database/features/instant-client/index.html
The size of the full Oracle client download is almost as much as the download of the newest release of the whole SQL Server RDBMS :w00t:
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 15, 2012 at 1:17 pm
Thanks everybody for your reply
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply