Viewing 15 posts - 1,291 through 1,305 (of 3,738 total)
So far I'm good to go.
I installed the 32 bit Oracle Client from the Command Line and that worked out and was able to creating an SSIS Package to load...
July 13, 2012 at 4:30 pm
I realize what the warning is about.
It is the default code page property for the OLE DB Source which is Oracle which is set to 1252.
There is another property "AlwaysUseDefaultPageCode".
You...
July 12, 2012 at 8:57 am
Sorry. I should have posted that I got this to work frst thing yesterday morning by launching the UI from the command line. No need for an old version.
C:\Oracle_Client\32bit\client\SETUP.exe...
July 12, 2012 at 8:49 am
PaulB-TheOneAndOnly (7/10/2012)
Oracle home can be specified at the command line, like:./runInstaller ORACLE_HOME="OH_location" ORACLE_HOME_NAME="OH_name"
I believe that the ./runInstaller is for Unix but thanks for the tip.
I used the following and after...
July 11, 2012 at 8:32 am
prvmine (7/9/2012)
looks like you can get the client from here --
https://forums.oracle.com/forums/thread.jspa?threadID=944543
-- I...
July 11, 2012 at 6:15 am
PaulB-TheOneAndOnly (7/10/2012)
Oracle home can be specified at the command line, like:./runInstaller ORACLE_HOME="OH_location" ORACLE_HOME_NAME="OH_name"
Hope this helps.
What about ORACLE_BASE?, same syntax?
Are you sure that it is not setup.exe SET...?
July 11, 2012 at 5:42 am
PaulB-TheOneAndOnly (7/10/2012)
Oracle home can be specified at the command line, like:./runInstaller ORACLE_HOME="OH_location" ORACLE_HOME_NAME="OH_name"
Hope this helps.
I saw that syntax as well but I do not understand how that would work? What...
July 10, 2012 at 5:18 pm
How did you create the linked Server? It is probably not the Linked Server but the OLE DB Driver.
July 10, 2012 at 12:34 pm
Did you install the mas90 drivers?
After that did you create a DSN?
July 10, 2012 at 11:03 am
prvmine (7/9/2012)
The Oracle Universal Installer does not have a Drop Down Box where you can specify...
July 10, 2012 at 7:52 am
The following articles are a start:
July 10, 2012 at 6:39 am
prvmine (7/9/2012)
according to Microsoft you do, if you want both to develop and to run SSIS packages on a 64-bit computer:http://msdn.microsoft.com/en-us/library/ee470675(v=sql.100).aspx
I understand that you need both a 32 &...
July 10, 2012 at 5:53 am
I mentioned using the DataTimeOffset and they did not like that one.
If I have a TimeStamp in Oracle then why I should not use a DATE2 Datatype to load into...
July 9, 2012 at 10:11 am
May I please get Oracle Client 11g 11.1.0.7.0?
July 9, 2012 at 6:41 am
Viewing 15 posts - 1,291 through 1,305 (of 3,738 total)