[ciapug] [OT] MS DTS

[Barry Von Ahsen]

I have a function to do proper case on a string since stupid VBA doesn't 
have stupid strConv()

Is there a way to create an ActiveX task in dts, and have all of my 
conversions refer to that, so that if I have to update the function, I 
can update the task instead of updating 50 data pump tasks?  Or would 
this require compiling a dll?

Or am I doing this backwards?  Is this better to do on the frontend, 
rather than the backend? (although it's a little late for that now)

-barry