Can anyone tell me how to launch a DTS package in SQL Server from a VB app?  I'd rather not have to call a batch file that runs it... I'd rather not have any extra files to install on the users' machine.

Thanks!

Many different ways exist, however, most I believe require the SQL components to be installed on the machine.

There is another option that I believe will work (although you'll have to use a generic account that has access to the master db [msdb] such as the sa account) that doesn't require any additional files.

First, you'll have to make a job that will run the DTS package, then you can do the following:

Connection.Execute "sp_start_job @job_name='JobName'"

Of course you could also schedule a trigger on a table that will run a package, but the above may be the easiest.

____________________________
Everywhere's Local (classifieds, job postings, & more for everycity in the world - user entered)