Hi All I need to move the data from oracle to SQLserver tables.In connection manager i choosen oledb provider for oracle and server name,username and pwd details.But i am getting below error.One more thing my operating system is windows7 64 bit.Please help to fix the error or connect to oracle Listner was not given the service_name in connect_data Thanks CMK

Hi CMK, you need to configure TNS before attempting to connect It seems this issue is solved in this forum http://stackoverflow.com/questions/4825552/ora-12504-tnslistener-was-not-given-the-service-name-in-connect-dataArthur My Blog