Where can I find a list of DTS objects and their properties?

Thread View: comp.databases.ms-sqlserver

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Mike Kusar Tue, 24 Aug 1999 00:00

#138

Author: Mike Kusar
Date: Tue, 24 Aug 1999 00:00

9 lines
1542 bytes

I would like to write an ActiveX script that configures a DTS package
according to its global variables (setting up file names for instance).  The
examples at http://www.swynk.com/friends/green/ were helpful but only
mentioned the .Value property of a connection.  What about Execute Process
Tasks and Execute SQL Tasks?  How do I access members of those collections?
And what are the properties I can access?

I guess I'm used to the way Visual Basic offers a dropdown box listing an
objects methods and properties.  Is there something similar for DTS?

Re: Where can I find a list of DTS objects and their properties?

#139

Author: Jerry Spivey
Date: Tue, 24 Aug 1999 00:00

20 lines
1618 bytes

Mike - Take a look at the DTS Programming under Building SQL Server
Applicaitons in the SQL 7 BOL for DTS objects and properties.  You might
also find additional information at MSDN On-Line.

HTH

Jerry
Mike Kusar wrote in message ...
>I would like to write an ActiveX script that configures a DTS package
>according to its global variables (setting up file names for instance).
The
>examples at http://www.swynk.com/friends/green/ were helpful but only
>mentioned the .Value property of a connection.  What about Execute Process
>Tasks and Execute SQL Tasks?  How do I access members of those collections?
>And what are the properties I can access?
>
>I guess I'm used to the way Visual Basic offers a dropdown box listing an
>objects methods and properties.  Is there something similar for DTS?
>
>

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads