dbTalk Databases Forums  

Custom properties in custom pipeline component.

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Custom properties in custom pipeline component. in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Joe
 
Posts: n/a

Default Custom properties in custom pipeline component. - 02-24-2005 , 09:11 AM






I've written a custom component for SSIS that validates and formats a given
input against a specified regular expression. To achieve this I've set up
three custom properties that can be assigned on each of the input columns.

1) Output Case (i.e.: UPPER, lower, Title)
2) Regular Expression (i.e.: (\d{3,4})\s(\d{3})(\d{4}))
3) Output Format (i.e.: ($1) $2 $3)

The component's working fine, but I'am not 100% happy with the UI aspects.

At the moment I've defined an enumerator inside the component that stores
the 3 available options for changing the case of the output. The result of
this is that in the designer I have to specify 0, 1 or 2 for each item in the
enumerator. This is fine at the moment, but obviously, not user friendly!

I'd like to be able to display these three options in a combo box, but can't
find anything in the object model that will let me do this.

Have I missed something or is this not possible at the moment?

I'am working with Beta 2 BTW.

TIA

Joe

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.