Error out description issues when migrating packages to Sql 2012

Feb 9, 2015 at 11:24 PM
HI ,
I am facing issues when i am trying migrating SSIS packages created in VS 2008 to sql server 2012 with "Error output description" component .
Is their new upgrade available for 2012 server or Can i still use the same 2008 dll for 2012.

Thanks in advance!
Coordinator
Feb 10, 2015 at 9:58 AM
Unfortunately there are no 2012 version of this component.
If you have Visual Studio, maybe you can recompile the dll for the 2012 version and make it available to everyone on codeplex. (I don't have access to these Tools anymore).
Thank you.
Jun 24, 2015 at 5:33 AM
Hi,

I have downloaded your source code and recompiled with with .Net 4 framework.
It then successfully appear in SQL server data tool for SSIS 2012.
But when I used it, it always give some wired issue, such as

Warning: 0x0 at Deal Info, Error Description: Modification have been detected in input columns : Exception from HRESULT: 0xC0047072
Warning: 0x0 at Deal Info, Error Description: Modification have been detected in input columns : The column Flat File Source Error Output Column has been deleted.
Error: 0xC0047062 at Deal Info, Error Description [199]: System.Runtime.InteropServices.COMException (0xC0010009): Exception from HRESULT: 0xC0010009
at Microsoft.SqlServer.Dts.Pipeline.Wrapper.IDTSOutputColumnCollection100.RemoveObjectByID(Int32 lID)
at Pestre.SqlServer.SSIS.DataFlowComponent.ErrorOutputDescription.ReinitializeMetaData()
at Pestre.SqlServer.SSIS.DataFlowComponent.ErrorOutputDescription.Validate()
at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostValidate(IDTSManagedComponentWrapper100 wrapper)
Error: 0xC0047017 at Deal Info, SSIS.Pipeline: Error Description failed validation and returned error code 0xC0010009.
Error: 0xC004700C at Deal Info, SSIS.Pipeline: One or more component failed validation.
Error: 0xC0024107 at Deal Info: There were errors during task validation.

Any code change would required for this to be working?

Thanks a million!