Error Scheduling DTS w/ IBM AS400 OLE DB

[ktmonster]

Help! I am trying to use the IBM AS400 OLE DB provider to set up a DTS package and job. The job executes a total of 10 DTS packages that I have set up to bring over tables from the AS400. I am trying OLE DB because Client Access is so slow. When I schedule the job, I get the following error message.

DTSRun OnError: DTSStep_DTSDynamicPropertiesTask_1, Error = -2147217886 (80040E22) Error string: Non-NULL controlling IUnknown was specified, and either the requested interface was not IUnknown, or the provider does not support COM aggregation. Error source: Microsoft OLE DB Service Components Help file: Help context: 0 Error Detail Records: Error: -2147217886 (80040E22); Provider Error: 0 (0) Error string: Non-NULL controlling IUnknown was specified, and either the requested interface was not IUnknown, or the provider does not support COM aggregation. Error source: Microsoft OLE DB Service Components Help file: Help context: 0 DTSRun OnFinish: DTSStep_DTSDynamicPropertiesTask_1 DTSRun: Package execution complete. The step failed.

Can anyone tell me what I'm missing here? Thanks!

 

[john76]

I know this doesn't help you with your problem exactly, but this is something I heard from IBM, which may or may not be true. I really don't know as I haven't tested it myself.

From what they told me though, ODBC does have additional overhead than OLE DB, and therefore does take longer to connect to the database, but once the connection is established the actual data tranfer is faster than with OLE DB. Therefore if you are transferring large tables you will get better results using ODBC.

Again, I don't know whether or not that is true or bull, I was never able to make OLE DB work on my system with AS/400 (iSeries). This is just what an IBM tech said.

Anyway, what version of Client Access are you using? Mine was upgraded a few months back (I don't remember the version offhand, 5.2 I think...) and there was a definate performance boost.

HTH,
John