December 30, 2009 at 7:06 am
In my Oracle10g Server i have all the tables in my other users folder with database name. Tried to connect using SSIS ...After i have given all the required credentials regarding the server names and test connections... getting success message...and in data access mode i selected the "table and view" option then i dint get the list of tables in the " Name of the table or view" textbox( It says Loading...after a few moments im getting error ...).
Error:-
Could-not retrive the table information for the connection manager ‘gmdev.ram’.
ORA-00376:file2 cannot be read at this time
ORA-01110:data file 2: ‘+DATA/gmdev/datafile/sysaux.2932.70265089’
ORA-06512: at ‘SYS.XML_SCHEMA_NAME_PRESENT”, LINE 17
December 30, 2009 at 7:43 am
I have had a similar issue when connecting to MySQL i could connect fine but was unable to see the table definitions, I think it is a limitation of the ODBC driver.
What worked for me was to use a sql query as the data source
eg. select Col1, Col2 from TableA
I verified the query worked on the server and then put the query into the data source and it ran without a problem..
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply