SSIS conection to Oracle

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
Posts: 1
Joined: Sat 24 Oct 2009 21:57

SSIS conection to Oracle

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.

Site Admin
Posts: 8248
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Tue 27 Oct 2009 15:59

Could you please send us via 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.

Post Reply