ETL fails when being run from the SQL job.(Error 0xC0011008 while preparing to load t

[aleks1874]

Dear all, let me describe the situation:

I have the set of packages, stored in MSDB.
There is a main package, calling a set of ‘child’ packages.
(It’s stored in MSDB by itself, as well as all child ones it calls)

When I run the whole solution from the VS – it works fine. No failures.
When I deploy the solution to the MSDB and run the main package from the job – job fails.(means one of the packages being called - fails)

From the sysdtslog90 I see, that some of the packages fails with the error message:

Error 0xC0011008 while preparing to load the package. Error loading from XML. No further detailed error information can be specified for this problem because no Events object was passed where detailed error information can be stored.

Any ideas, why this can happen and how can this be solved?
Your help is much appreciated.

[Island1]

Was this an upgraded package?

Thanks.

[narlo]

• What is the datatype the xml data is stored in MSDB ... TEXT, XML, or VARCHAR(MAX)?

• What gateway are you using?

The reason I ask is the Oracle gateway for 10/11g only supports ETL transfers upto 32K blocks of data when converting from TEXT & VARCHAR(MAX) Datatypes to LONG.

We're testing the XML Data ETL as type XML from MSDB this coming week (05/10/2010)

There are several open support tickets about this with Oracle.