Hi, I am trying to use SSIS to import data from a XML file. One of the element in the XML file contains binary data of a pdf file. I created a SSIS package and setup the column properties of the XML source to DT_BYTES and also tried DT_IMAGE. But I get the following error.
Error: 0xC0209029 at Data Flow Task, XML Source [1253]: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "component "XML Source" (1253)" failed because error code 0x80131941 occurred, and the error row disposition on "output column "DOCUMENTBLOB" (1279)" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure.
Error: 0xC02092AF at Data Flow Task, XML Source [1253]: The component "XML Source" (1253) was unable to process the XML data. Pipeline component has returned HRESULT error code 0xC0209029 from a method call.
Any pointers would be very helpful