Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 retrieving dts package name in activeX component

Author  Topic 

ehague
Starting Member

1 Post

Posted - 2002-02-12 : 17:44:27
i am writing vbscript in my activeX component. I need to refer to the name of the entire dts package and use it as a variable. My question is how can I retrieve the actual name of the package in vbscript?

liz

Spyder
SQLTeam Author

75 Posts

Posted - 2002-02-13 : 00:11:28
Gert Drapers from Microsoft did an excellent presentation on Programming DTS using Visual Basic 6.0 at the January 2002 PASS conference in Denver. I believe what you are looking for is covered under the topic of 'Package Enumeration'. See the following links for some great DTS resources that cover this topic:

[url]http://www.sqldts.com[/url]
[url]http://www.sqldev.net[/url]



Go to Top of Page
   

- Advertisement -