Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cstokes91
Yak Posting Veteran
72 Posts |
 Posted - 2012-12-12 : 12:00:57
|
| Hey,I am having some issues getting the tool from Oracle to work on SSIS. The environment is a Windows Server 2008 and I have tried http://www.oracle.com/technetwork/database/windows/downloads/index-090165.html but didn't have any luck.What I am looking for is when I go into import, I can select the drop down option labeled Oracle Provider for OLE DB.The reason I have to use that is the one Microsoft has built in does not work with the version of Oracle the client has (very old version). Thanks for any assistance! |
|
|
srimami
Posting Yak Master
160 Posts |
Posted - 2012-12-18 : 03:58:15
|
| Create a simple job using Database connection as Oracle rather than built in IMPORT/EXPORT. Even Import/Export shouldn't have any problem but no guess work unless we see the exact problem |
 |
|
|
|
|
|
Data from Oracle to SQL Server using SSIS