This project has moved. For the latest updates, please go here.

XMLify not working with SQL 2014

Apr 29, 2014 at 1:32 PM
Hello,
We've been using XMLify successfully with SSIS 2012. We've migrated the packages to SQL 2014, and we're getting the following error:


DFT Process_GAA_5000 Upsert:Error: System.InvalidCastException: Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.SqlServer.Dts.Pipeline.Wrapper.IDTSComponentMetaData100'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{887BD061-82D4-4F06-A222-337D42E7F896}' failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)).
at System.StubHelpers.StubHelpers.GetCOMIPFromRCW(Object objSrc, IntPtr pCPCMD, IntPtr& ppTarget, Boolean& pfNeedsRelease)
at Microsoft.SqlServer.Dts.Pipeline.Wrapper.IDTSComponentMetaData100.get_CustomPropertyCollection()
at Tjoc.SqlServer.Dts.Pipeline.Xmlify.XmlifyTask.PreExecute()
at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPreExecute(IDTSManagedComponentWrapper100 wrapper)
DFT Process_GAA_5000 Upsert:Error: Xmlify Date Columns failed the pre-execute phase and returned error code 0x80004002.

Does anyone have suggestions on how to fix this?

Thanks!
Shannon
Coordinator
May 11, 2014 at 1:40 PM
Edited May 11, 2014 at 1:40 PM
Hi Shannon
Sound like I will need to create a updated version of the XMLify task for SQL Server 2014. I will look in to this soon.

Regards
Steve
May 12, 2014 at 1:30 PM
Thank you, Steve! We use this in several hundred SSIS packages, and we really need it! :-)