SSIS conection to Oracle

gt1962 · Post by **gt1962** » Sat 24 Oct 2009 22:11

I was trying to extract data from an oracle database. It works fine in VS designer without a config file but when I batch the job in SQL Server it fails. When I use a config file it fails also. I was wondering:

1. Do I need to use a configuration file to save the oracle username/password or any other info?

2. When I do use a config file I get a cryptographic password error.

My other SSIS packages that connect to SQL to SQL databases works ok when scheduled.

We chose to use dotConnect for oracle so that we can connect to different versions of oracle from 8 to 11 since we couldn't use oracle client in the same way.

Shalex · Post by **Shalex** » Tue 27 Oct 2009 15:59

Could you please send us via http://www.devart.com/company/contact.html a small test project that reproduces the problem? Do you use BIS 2005 or BIS 2008? Please tell us the steps we should follow to reproduce the issue.