Manually start a DTS through Access?

[balistikb]

Is there a way to manually run a DTS through access?
I need to give the user a way to run this DTS without having them use SQL.
Is it possible?

 

[JayKusch]

Check out the dtsrun Utility. It is in Books Online if you have access to that. If not ... a search will find info on it.

Thanks

J. Kusch

 

[balistikb]

But can the DTSRun utility get exicuted from Access?

 

[john76]

I'm not sure exactly how to answer your question, but DTSRun is a command-line program so if Access can call a DOS command (I'm pretty sure it can) then the answer is yes although I'm not exactly sure of the mechanism.

 

[balistikb]

Ok I will try. Thank you.