locked
CustomProperty TypeConverter RRS feed

  • Question

  • Environment :- C#, Visual Studio 2008, Windows Server 2003

     

    Hi, I have recently begun developing a custom Source Component for querying an instance of CRM.  My custom component has two custom properties which are created using the IDTSCustomProperty object.

     

    I would now like to add a custom property which displays and list of supported connection managers in a Dropdown List within the Properties pane.  I have read the following post List all your connection managers and sadly have made no further progress.  I am a complete novice when it comes to TypeConverters and have no experience in this area.

     

    Please could someone point me in the right direction or even provide me some sample source code that my help resolve this issue.

     

    Many thank

     

    Iain Lomax  

    Thursday, July 16, 2009 9:41 AM

Answers

  • There is complete sample available in the download from a presenation I did on developing custom tasks - Extending SSIS with Custom Tasks .

    This actually uses a UITypeEditor not a TypeConverter, as it allows more flexibility and most importantly here we can capture the selection event and react to it, so it allows us to include a <<new connection>> option in the drop-down and invoke the new connection dialog etc.
    http://www.sqlis.com | http://www.konesans.com
    Thursday, July 16, 2009 10:49 AM

All replies

  • There is complete sample available in the download from a presenation I did on developing custom tasks - Extending SSIS with Custom Tasks .

    This actually uses a UITypeEditor not a TypeConverter, as it allows more flexibility and most importantly here we can capture the selection event and react to it, so it allows us to include a <<new connection>> option in the drop-down and invoke the new connection dialog etc.
    http://www.sqlis.com | http://www.konesans.com
    Thursday, July 16, 2009 10:49 AM


  • Hi Darren,

    Many thanks for your response - the presentation and code sample was extremely helpful.

    Regards

    Iain
    Friday, July 17, 2009 8:26 AM