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
 SQL Server Development (2000)
 Using VB to create an add-on to change DTS packages

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-03-05 : 00:24:22
Jason writes "I am trying to write a small VB app to help myself and our DBA to control our sql7.0 dts packages a little easier. - It has struck me that doing certain things is either somewhat laborious or sometimes easier to delete a DTS Package and start again.

I know the is a com interface for the dts and I have set my references etc. but I am having trouble loading an existing dts package using the loadfromsqlserver method. most of the examples in Book Online are written in C++ and the few VB samples that are on the SQL7.0 CD-Rom do not appear to work.

I have searched most of the SQL-help site but cannot really find any articles on this subject.

Thanking in advance for any help given

Jason Woolf"
   

- Advertisement -