Execute SQL DTS From Access

To setup SQL Server DTS package execution in MS Access:
- Perform a Save As... on the DTS package.
- Save the file as a .bas Visual Basic File.
- Paste the .bas file into your MS Access Modules.
- Add a function to call the main subroutine in the file.
- Call the function in the MS Access Module with a Run Code routine.
- Place the macro call in a button on your form for processing by the targeted user.