SSIS conection to Oracle

SSIS conection to Oracle

Postby 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.
gt1962
 
Posts: 1
Joined: Sat 24 Oct 2009 21:57

Postby 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.
Shalex
Devart Team
 
Posts: 7773
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle