I've saved a dts package as a structured storage file and am trying to execute it from a stored procedure using the following-

CREATE PROCEDURE run_dts AS

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, '\\server\directory\package.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
GO

If I execute the code from within query analyzer it gives me "The command(s) completed successfully."

If I execute the stored procedure from query analyzer I get -

Stored Procedure: catalog.dbo.run_dts
Return Code = 0

In both cases, nothing is happening, no data import.

I am executing with a sysadmin role...

Any ideas?