locked
SSIS Custom components in ToolBox-How to determine Source /Destination Component RRS feed

  • Question

  • Hi All,

    I have two custom components.One source component and one destination component.
    When I right clik and add to tool box it will open up a window and from the SSIS DataFlow Components tab I can select my source and destination compoents.If I select both it will automatically go under Source and destination componets in SQL 2005.But in SQL 2008 it is getting added under same place.
    Is there any property I need to set to make sure that the Source custom component should add under DataFlow Sources and destination component should add under DataFlow Destination.

    I am facing this issue only in SQL 2008.In SQL 2005 it is working fine.

    Regards,
    Seena
    Monday, August 9, 2010 8:43 AM

Answers

  • The DtsPipelineComponent attribute used to decorate your class includes the ComponentType property which should control the toolbox, BUT it doesn't work properly. As I recall it uses the currently selected toolbox section, hence your issue.
    http://www.sqlis.com | http://www.konesans.com
    Monday, August 9, 2010 8:53 AM

All replies

  • The DtsPipelineComponent attribute used to decorate your class includes the ComponentType property which should control the toolbox, BUT it doesn't work properly. As I recall it uses the currently selected toolbox section, hence your issue.
    http://www.sqlis.com | http://www.konesans.com
    Monday, August 9, 2010 8:53 AM
  • But in SQL Server 2005 wherever i select the position in toolbox,it will go and add the Souce component in Source Position,and Destination component in Destination position.

    I am facing this issue only in SQL 2008,evenif i set the ComponentType property.

     

    Wednesday, August 11, 2010 4:39 PM
  • "But"?

    It's unfortunate that you don't like the answer - I don't either - but that doesn't make it incorrect.


    Todd McDermid's Blog Talk to me now on
    Wednesday, August 11, 2010 5:16 PM
  • I agree... doesn't fix it though ;)
    http://www.sqlis.com | http://www.konesans.com
    Wednesday, August 11, 2010 8:19 PM