Hi all,

I have a prob with the dts when it is executed from the vb 6
application.When i invoke the dts from my application , my prog is not
responding untill the completion of the dts.

But i need to get the control when it is getting executed.What should i
do..


Thanks for any help
Shiva G

Hi Shiva,

I also tried to run a dts saved as vb6 module file in a vb6 project (the dts
is to upload a text file into database). The call to execute the dts was
running without any error message. But when I checked the database no file
had been loaded. In other words, my vb6 project was able to call the dts, but
the dts did not do anything.

If you can make a dts work from your vb6 program, can you share your
knowledge. Thanks,

Tom

"shiva" wrote:

I think TOM BP is asking a new question - I'll stick with an answer to
the original post.

VB6 threading is pretty old - likely not too easily accomplished accept
by guru. Explore the possibility to using a commandshell callout to (or
switch to VB.Net that has execellent threading)

START DTSRun <test.dts> /aparm:8=value <log parms etc>

or

Create a SQL-JOB that uses DTSRun to execute the package then schedule
to SQL-JOB to watch for and execute when a custom event message is
revieved via ADOCommand such as:

RAISERROR ('package ABC execute event by %s', 10, 1, 'application abc')

The package in either of these cases would execute un-attended though -
that might not be what you were hoping to achieve.

Alternatively teach the package how to watch for and continue or
terminate based upon a custom application flag and merely execute it
every 5 minutes - this would avoid the possibility of multiple clients
attempting to execute the SQL-JOB at the same time - hmm actually a
SQL-JOB is synchronous already I think -- nevermind that --.

Cheers
http://rickhathaway.blogspot.com/