MegaPowerRockstar Posted May 10, 2014 Report Posted May 10, 2014 Hi Frndz, I need some help in implementing SSIS. I am trying to connect to oracle db from ssis package using odbc .... i was trying to provide connection string and connect... But i am getting an error.... it says connection could not be instantiated.... Can some one provide some guidance of how to provide a connection string , like the exact format.. I have host name, port no, service name, user id and password....are these enough?? Could anyone please provide the connection string syntax for above info.. also is it possible to set the connection string in a variable and call in the connection of an oledb source ??
cool_dude Posted May 10, 2014 Report Posted May 10, 2014 Bhaiyya there is a 3rd part tool wch is can be connected to oracle through ssrs. Try installing attunity ....ssis pkg reopen cheyyu install Chesaka...u could see attunity tools in toolbox
mettastar Posted May 11, 2014 Report Posted May 11, 2014 Bhayyabnaku SSIS thelvadhu kaani.. check if u have oracle client installed
libraguy863 Posted May 11, 2014 Report Posted May 11, 2014 We had an issue a while ago , but it was resolved it was related to something about the 32bit and 64bit connectionmanager for Oracle..
cool_dude Posted May 11, 2014 Report Posted May 11, 2014 Yes true check the oracle client version. What evr your compatibility 2008/R2/2012 oracle client 32 bit install chesko bhaiyya... I had the same issue recently and I struggled almost 3 days for connection.
MegaPowerRockstar Posted May 11, 2014 Author Report Posted May 11, 2014 Yes true check the oracle client version. What evr your compatibility 2008/R2/2012 oracle client 32 bit install chesko bhaiyya... I had the same issue recently and I struggled almost 3 days for connection. naku adhe doubt undhe...already maa vadee ke cheppa version compactability issue annee.... maa client lo recent ka softwares anne server lo install chesaruu....manam server ke login ayyeee development chesukovalee.... check chesthannu aa server lo eme drivers install ayye yo.. easy work....db connectivity valla time anthaaa waste authundhe...
MegaPowerRockstar Posted May 11, 2014 Author Report Posted May 11, 2014 Bhayyabnaku SSIS thelvadhu kaani.. check if u have oracle client installed it is installed bhaya.... i am able to login from sql developer and access db and work on it.
MegaPowerRockstar Posted May 11, 2014 Author Report Posted May 11, 2014 SS 2008 R2 or 2012...? BIDS 2008
mettastar Posted May 11, 2014 Report Posted May 11, 2014 it is installed bhaya.... i am able to login from sql developer and access db and work on it. Nee system lo kadhu bro.. where ur SSIS IS installed.. SSIS unna server meda Oracle client install chesi undali kadha.. That way u can create a odbc connection on that server(SSIS unna server) to talk to oracle server..
MegaPowerRockstar Posted May 11, 2014 Author Report Posted May 11, 2014 Nee system lo kadhu bro.. where ur SSIS IS installed.. SSIS unna server meda Oracle client install chesi undali kadha.. That way u can create a odbc connection on that server(SSIS unna server) to talk to oracle server.. ohk....thanks bro...i will check on this... but we are using server,,so both should be thereee
Recommended Posts