Oracle 10g Source + Multiple-step OLE DB operation

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SSIS and Import/Export (2005)

Oracle 10g Source + Multiple-step OLE DB operation

Author

Topic

satish.t@dexterity.in
Starting Member

2 Posts

Posted - 2009-01-06 : 04:46:19

Hi,
I am getting error when I am trying to execute the package from comand line...
An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040E21 Description: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.".

Details :
Oracle 9i client on my system
Oracle 10g is the server : Source
Protection level : EncryptAllwithPassword
Driver(tried both of them):
Native OLE DB\Microsoft Ole Db provider for Oracle
Native OLE DB\Oracle provide for OLE DB

but for all cases I am stuck up at the same point with the same error. Any help would be greatly appreciated.

satish.t@dexterity.in
Starting Member

2 Posts

Posted - 2009-01-06 : 09:16:21

Hi.... cheers I managed to overcome the problem.
1. The problem was with the path variable. I was having path for my other version of ORacle which I remeoved from the path variable and kept only for the version I am using.
2. In the config file see that only the connection string parameter is there no other need to be selected and add Password=Urpassword;
as some of the tags are not supported by Oracle in web config...

and tada... I was done....

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources