I am currently developing a custom transform for our datamart ETL. The idea
is to do foreign key lookups directly in the transform to convert incoming
strings to the correct IDs. This is similar in principal to the idea of
using a lookup but much faster.

One question I have, is it possible to add a custom user interface to the
transform similar to a custom task UI? None of the samples use a custom UI
and usually just expose some properties that are visible with the standard
property UI.

Thanks in advance,
James Snape

Hello Jim,

I would appreciate you patience while I am having DTS expert look into this
issue.

Thanks for using MSDN Managed Newsgroup.

Vikrant Dalwale

Microsoft SQL Server Support Professional


Microsoft highly recommends to all of our customers that they visit the
http://www.microsoft.com/protect site and perform the three straightforward
steps listed to improve your computer’s security.
This posting is provided "AS IS" with no warranties, and confers no rights.



--------------------
..phx.gbl

Hi James,

DTS does not programtically expose an interface for a custom transform UI
as is the case with a custom task UI. Therefore, one cannot create a custom
UI for a custom transform.

Hope this helps.


Farooq Mahmud [MS SQL Support]

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.

Well it doesn't really help as the answer is no - but I'll get over it...

So how come the "DateTime String", "Middle of String", "Read File", "Trim
String" and "Write File" transforms all have custom dialogs when you click
the Properties button? Is this a hidden Microsoft API or have you gone and
embedded transform specific code in the global transform options dialog?

Regards,
James Snape


"Farooq Mahmud [MS]" <farooqm (AT) online (DOT) microsoft.com> wrote

Those transforms are probably implementing an internal DTS interface which
was never exposed to the outside.

Regards,
Farooq Mahmud [MS SQL Support]

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.

Hi James,

How is the issue going on your side? Let us know if you need further
assistance on this issue.

Regards,

Bill Cheng
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
--------------------
..phx.gbl!TK2MSFTNGP09.phx.gbl

Hi Bill,

I think the previous posts from Microsoft were fairly conclusive: you can't
create custom UI's and any interface is a private Microsoft only one. Not
much more I can do here...

Regards,
James Snape

""Bill Cheng"" <billchng (AT) online (DOT) microsoft.com> wrote