Custom source component: how to delete already attached output during design time?

• RArenz

  Grasshopper

  Points: 11

  More actions

  January 18, 2012 at 9:12 am

  #266895

  Hello!

  I'm developing a custom source component using SQL Server 20108 R2 and Developer Studio 2010.

  The component creates and deletes outputs during design time.

  That works fine as long as I don't try to delete an output that has already been attached to a downstream component. If I try this, I get an error message about a HRESULT E_FAIL error occurred during a call to a COM component, and the path between both components still exists (in the designer) but not in the source component's OutputCollection. For me it seems as if the output was deleted (out of the output collection) but the path object still exists, referencing now an invalid output object.

  That's what I try in order to delete an output:

  1. Validate() return DTSValidationStatus.VS_NEEDSNEWMETADATA.

  2. ReinitializeMetaData() deletes the output using DeleteOutput(). I have also tried ComponentMetaData.OutputCollection.RemoveObjectByID() but that didn't help, too.

  Maybe it is necessary to delete the IDTSPath100 manually before I delete the output? But I don't know how to find the path object.

  Any suggestions?

  Thanks in advance

• RArenz

  Grasshopper

  Points: 11

  More actions

  January 20, 2012 at 8:53 am

  #1436563

  Okay,

  my fault: nothing was wrong with deleting an output during design time. The error was found in a completly different location.

  Regards