Is there a way to call DTS Designer programmatically ?

Is there a way to call DTS Designer programmatically ?

Post by Lee Gilli » Sun, 01 Feb 2004 01:33:08


I found a few entry points in dtsui.dll which look like they may do the job. ActivateDesignerWindow, CloseDesignerWindow,
CreateDesignSurface, InvokeDesignerCommand. I have not found a COM interface for this DLL. I don't know what the call parameters
are. We are doing package management outside of Enterprise Manager, and it would be NICE to be able to pull up these packages for
editing in our tool. Does anyone know how to get a DTS Designer session opened for a package found in a structured storage file?
 
 
 

Is there a way to call DTS Designer programmatically ?

Post by Darren Gre » Sun, 01 Feb 2004 05:30:20

In message <#mdt$ XXXX@XXXXX.COM >, Lee Gillie
< XXXX@XXXXX.COM > writes

I do not believe this is possible, and it is certainly not documented.
You could write your own layout designer, and then just invoke task UIs
as required. Not an easy job though.

--
Darren Green (SQL Server MVP)
DTS - http://www.yqcomputer.com/

PASS - the definitive, global community for SQL Server professionals
http://www.yqcomputer.com/

 
 
 

Is there a way to call DTS Designer programmatically ?

Post by Lee Gilli » Sun, 01 Feb 2004 07:20:48

Darren -

Just knowing that it can't be, or knowing it might be (with a huge amount of effort) is very helpful. I always appreciate your
taking time to share your vast DTS experience with newbies like me, as I push ahead to ask every dumb question that occurs to me!!
;)

Best regards - Lee Gillie