Running a DTS package through VB code from a front end

[ksarma11]

I have a DTS package which I need to run once a month every month. But this should happen only when the user who logs in clicks a button from the front end. Is this possible? or will the best way be to schedule the package to run at the end of the month as a scheduled job?..

Thanks

 

[SQLSister]

I never tried this, it is just a thought. Could you have the button run a stored procedure that runs a job to execute the DTS package? Try the sp_start_job system stored procedure.

 

[tlbroadbent]

You can easily execute a DTS package from a VB program. Check the articles at SQLDTS.COM.

http://www.sqldts.com/catlist.asp?nav=1,6,104,5

See faq183-962, "Where can I find more DTS information and samples?" for more DTS resources.
Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.