There are two ways to run a DTS package from the Query Analyzer or stored procedure:

1. By using OLE Automation objects
(run sp_OACreate, sp_OAGetProperty, sp_OAMethod and so on).

2. By using xp_cmdshell stored procedure to run dtsrun.exe file.

This is the example to execute NewPack.dts package from the disk C:

DECLARE @object int
DECLARE @hr int

--create a package object
EXEC @hr = sp_OACreate 'DTS.Package', @object OUTPUT
if @hr <> 0
BEGIN
    print 'error create DTS.Package'
    RETURN
END

EXEC @hr = sp_OAMethod @object, 'LoadFromStorageFile',
     NULL, 'C:\NewPack.dts', ''
IF @hr <> 0
BEGIN
    print 'error LoadFromStorageFile'
    RETURN
END

EXEC @hr = sp_OAMethod @object, 'Execute'
IF @hr <> 0
BEGIN
  print 'Execute failed'
  RETURN
END