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

[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.