Error After Package Configuration

I have a package that executes succesfully before package is configured.

but when package is configured to use configuration details either from SQL Server configuration table or XML configuration file, gives an error :

[Connection manager "XYZ"] Error: An OLE DB error has occurred. Error code: 0x80040E21. 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.".

Can anyone help me out with this ?

Experts !!! this is my second post, my previous post is still unanswered.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1793362&SiteID=1

Can you share the configuration for connection manager "XYZ"? Also, are there any other error messages?|||

Details for Connection Manager XYZ

Provider: Native OLE DB\Microsoft OLE DB Provider for Oracle

Server Name : Ora_serv

UserName: User1

Pawwword: Password

Execution Result :

[DTS.Pipeline] Information: Validation phase is beginning.
Progress: Validating - 0 percent complete
Progress: Validating - 50 percent complete
[OLE DB Source "PQR" [1]] Error: The AcquireConnection method call to the connection manager "XYZ" failed with error code 0xC0202009.
[DTS.Pipeline] Error: component "OLE DB Source PQR" (1) failed validation and returned error code 0xC020801C.
Progress: Validating - 100 percent complete
[DTS.Pipeline] Error: One or more component failed validation.
Error: There were errors during task validation.
Validation is completed
[Connection manager "XYZ"] Error: An OLE DB error has occurred. Error code: 0x80040E21. 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.".
Validation is completed|||I'm curious... Do you have the Oracle client installed by chance? If so (and you need it to be), do you have "Ora_serv" listed in the tnsnames.ora file?|||

Yup !!! i have configured all the settings. After disabling the package configuration, package executes succesfully for the same connections details that are there in dtsConfig file. One thing that i have noticed, SSIS is not saving password in the config file. Even in Connection string SSIS is not saving password for oracle server.

|||SSIS won't save the password in the configuration file on its own. You can edit the configuration file yourself and add it though.|||I have tried that too, but it results in error given above.
Connection string works, but i want to use either SQL Server Table or XML file.