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
 Development Tools
 ASP.NET
 VB Executables

Author  Topic 

victord
Yak Posting Veteran

64 Posts

Posted - 2003-01-29 : 05:04:36
Hi All,

How do i create a Vb executable to run a SQL Server DTS process.
I have already created a module in Vb to represent this DTS process.
I need to find a way to create an executable to run this module.
Secondly ,on completion of the Dts process i will like a message boxx to pup up telling the user the process has finished.

If this is possible please help.

Thanks
Vic


Edited by - victord on 01/29/2003 06:52:11

ValterBorges
Master Smack Fu Yak Hacker

1429 Posts

Posted - 2003-01-29 : 07:40:02
Assuming you are using VB6 since you didn't mention .NET.

Take a look
http://groups.google.com/groups?q=DTS+object+vb&hl=en&lr=&ie=UTF-8&oe=UTF-8&selm=ZOfoePA9iib5EwnI%40freeserve.co.uk&rnum=10

Also you have two choices.
Create the DTS package in SQL Server and execute it from VB or
Create the DTS package in SQL Server and save it as a VB module.

Take a look
http://archive.devx.com/upload/free/features/vbpj/2000/14fal00/mh0014/mh0014.asp

http://archive.devx.com/upload/free/features/getstarted/2000/fall00/ss0004/ss0004.asp

for the message box take a look a the function msgbox



Edited by - ValterBorges on 01/29/2003 07:49:17
Go to Top of Page
   

- Advertisement -