HELP!

I created a VB to execute a DTS package and it runs well in my computer. (My computer installed SQL 2000 & VB 6.0)

However, when I try to use this VB to execute this package in another computer (SQL & VB not installed, but I have registered the necessary dll, rll and exe files in this computer), it is still not working. (Error message: Can't find file)

I saved this DTS package as a structured storage file in a shared folder.

Do I miss any step to execute this package by VB in another computer?

Thanks.

You may not have the right permissions to execute the DTS from the work station.

You may want to create a store procedure to call the DTS package then call the store procedure from the client. This will help not having to give users the permission to execute DTS. The stored procedure will run using the credentials from your SQLServerAgent account or other account that may have the right permissions.

You can also create a job of the DTS package, then create the stored procedure to stop and start the job. Use sp_startjob

Jaime E. Maccou