0

I have SSIS package which i connecting to a oracle server and truncate a table. If I configure the package using XML configuration my package is succeeding. I want to utilize SQL server configurations for my package. If I set that up, I'm not able to make a connection to oracle server.

Error Message:: "ORA-01017: invalid username/password; logon denied"

I think the issue is with the table where the configuartion values are stored When the package is trying to retreive password. Password fields are showing as asterisks. Any parameter or options I need to specify in this case? Please help!

RMu
  • 817
  • 2
  • 17
  • 41
  • Can your try this [link](http://stackoverflow.com/questions/18096409/connecting-to-oracle-database-using-sql-server-integration-services) – Dinesh Jan 12 '16 at 22:09
  • @Dhnesh I dont have any issue with Oracle connectivity. The issue is with using SQL server Configuration table – RMu Jan 14 '16 at 19:09
  • --Sql Authentication Data Source= ;User ID=; Password= ; Initial Catalog=; Provider=SQLNCLI10.1;Persist Security Info=True; --Windows Authentication Data Source= ; Initial Catalog=; Provider=SQLNCLI10.1;Integrated Security=SSPI; – Dinesh Jan 15 '16 at 15:12
  • try above one to connecting sql server – Dinesh Jan 15 '16 at 15:13
  • Have a look at the package protection level, if you are inside a strong protected network you could look to use "Don't Save Sensitive" - this may help? – Dominic Cotton Mar 08 '16 at 09:09

0 Answers0