I am running a SSIS package which has an Informix OLEDB Connection(32 bit). When I run from the Debug mode without the configuration file, the task completes successfully. But when I include the Informix OLEDB Connection in the config file and try to run the package, it fails with the following error.
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.”.
I assumed it must have something to do with the parameters in the config file, so at first I include all the parameters available for the OLEDB connection object. That Didn’t work so I decided to start eliminating properties that I felt were not essential. I finally got down to a minimal set of properties and the Informix connection worked successfully from the configuration file. I also encountered a similar issue connecting to Oracle via SSIS through OLEDB and the same configuration worked as well. Although I have not had a chance to test my hypothesis, I believe the culprit is the ConnectionString property.
Set your package protection level to “DontSaveSensative”
Only save the following properties to your xml configuration file: