Error at Data Flow Task [OLE DB Command [296]]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "Operand type clash: int is incompatible with xml". Error at Data Flow Task [OLE DB Command [296]]: Unable to retrieve destination column descriptions from the parameters of the SQL command. Error at Data Flow Task [SSIS.Pipeline]: "component "OLE DB Command" (296)" failed validation and returned validation status "VS_ISBROKEN". Error at Data Flow Task [SSIS.Pipeline]: One or more component failed validation. Error at Data Flow Task: There were errors during task validation. (Microsoft.DataTransformationServices.VsIntegration) If I remove the XML Datatype from the SP and the Execute query of Oledb Command. The Package works fine. As per the link below. This is a bug and has been fixed in latest releases: http://connect.microsoft.com/SQLServer/feedback/details/554514/error-with-xml-datatype-in-ole-db-commands-using-sqlncli10-1 Hence, updated the Sql Server and applied the latest patch from the link below: http://support.microsoft.com/kb/963036 But the issue is not resolved yet any help would be highly appreciated. Thanks in advance.

Can we see the query? Is the intent to dump some XML from source to destination? Dump the XML to a file then consume it (XML source -> OLEDB Destination), or you can implement your own XML Destination via a script as in http://agilebi.com/jwelch/2007/06/02/xml-destination-script-component/Arthur My Blog

Hi, I aim at passing an XML type variable from an Input file to a Stored Procedure. But SSIS doesn't allows the same. Please refer for error details: http://ssisdevelopers.wordpress.com/2012/01/23/bids-2008-does-not-support-xml-datatype-in-ole-db-command/ Have been passing the data as NVARCHAR(MAX) and type casting the same in the stored procedure. Any help to resolve this would be highly appreciated. Regards Bhavpreet Singh http://ssisdevelopers.wordpress.com/

yes, the work around works fine for me (2008 R2). Looks like this Issue has been resolved in Denali. Regards Madhavan.TR Madhavan Thasu Ramachandran