SSIS conection to Oracle
Posted: 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.
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.