dbTalk Databases Forums  

Is there a way to call DTS Designer programmatically ?

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


Discuss Is there a way to call DTS Designer programmatically ? in the microsoft.public.sqlserver.dts forum.



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

Default Is there a way to call DTS Designer programmatically ? - 01-30-2004 , 10:33 AM






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?



Reply With Quote
  #2  
Old   
Darren Green
 
Posts: n/a

Default Re: Is there a way to call DTS Designer programmatically ? - 01-30-2004 , 02:30 PM






In message <#mdt$605DHA.2404 (AT) TK2MSFTNGP11 (DOT) phx.gbl>, Lee Gillie
<ANTISPAMIFICATION_lee (AT) odp (DOT) com> writes
Quote:
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?

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.sqldts.com

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



Reply With Quote
  #3  
Old   
Lee Gillie
 
Posts: n/a

Default Re: Is there a way to call DTS Designer programmatically ? - 01-30-2004 , 04:20 PM



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

"Darren Green" <darren.green (AT) reply-to-newsgroup-sqldts (DOT) com> wrote

Quote:
In message <#mdt$605DHA.2404 (AT) TK2MSFTNGP11 (DOT) phx.gbl>, Lee Gillie
ANTISPAMIFICATION_lee (AT) odp (DOT) com> writes
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?


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.sqldts.com

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




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.