Error received is
OLE DB provider 'dtspackagedso' reported an error. Access denied.
[OLE/DB provider returned message: Access is denied.
]
OLE DB error trace [OLE/DB Provider 'dtspackagedso' IDBInitialize::Initialize returned 0x80070005: Access denied.].

DTS Package contains single Transform Data Task to retrieve 2 column from a single oracle table. DSO Rowset Provider is checked in the options tab.

Can anyone point me in the right direction?? Thanks!