Hi guys,

Im running win2k3 with oracle (9i and 10g) and mssql2005 in it. Having a
problem running my SSIS package that is fetching records from oracle 9i to
mssql. It stops in the oracle datasource. The connection is a native
Microsoft Ole DB connection for oracle. Here's the exact error that i got...

[Connection manager "OracleDS"] Error: An OLE DB error has occurred. Error
code: 0x80040E4D. An OLE DB record is available. Source: "Microsoft OLE DB
Provider for Oracle" Hresult: 0x80040E4D Description: "ORA-01017: invalid
username/password; logon denied ".

Eventhough, I checked the save password checkbox in the connection wizard.

Hope this is clear enough.

Many thanks in advance