You can also use VBA and ADO to execute a stored procedure that calls the DTS package. Here's an example of a stored procedure that uses the system stored procedure xp_cmdshell and the dtsrun.exe command to execute the package:

CREATE PROC ap_CallDTS

AS

SET NOCOUNT ON

DECLARE @cmd varchar(255)

DECLARE @error int

--command string

SET @cmd = 'dtsrun.exe /S MYSQLSERVER /U myusername /P mypassword /N MyDTSpackageName'

--Exec DTS package

EXEC @error = master..xp_cmdshell @cmd

Return @error