Hi, I'm trying to load some XML data in SQL Server using SSIS. I'm on SQL 2008. I've defined an XML data source and pointed it to my file and that part seems good. I've created a SQL Server destination task but I see some errors listed: Error 1 Validation error. Load XML Load XML Data to SQL Server [211]: The column "CategoryID" can't be inserted because the conversion between types DT_UI2 and DT_I4 is not supported. I tried going in the advanced editor and changing the data types on the destination to DT_UI2, but it always seems to revert back and never keeps my changes so I'm constantly seeing this error. Any ideas how to resolve this? Thanks, -Westside2008

Hi, You cannot convert the column data type over it self. You must generate a new column with the cast value, use a derived column or data conversion component. Use the new column to insert in destination. In Derived Column try a expression like this: (DT_I4) myIU2ColumnVctor M. Snchez Garca (ES) (BI) Hope this help. Please vote if you find this posting was helpful. if this is an answer to your question, please mark it. http://bifase.blogspot.com | http://twitter.com/atharky