>Hello All,
>
>I have a DTS Package that drops and access table then recreates the table with updated data. No return is available or required. How can I call this from either a stored procedure or visual basic application?
Right-click on the package and schedule it as a job. After that you can remove the schedule from the job and call it on demand by using sp_start_job from either query analyzer or a VB application through a plain ADO connection object.
The alternative is to call the DTSRUN utility directly from the VB app. The syntax for the call would be:
dtsrun /S myServer /E /N "My DTS package name"
The /E uses NT authentication, you can also specify UID and PWD. The advantage of scheduling the job via the right-click is that it creates the DTSRUN call automatically and encrypts all of the parameters including UID and PWD.