Hello evrybody,
I have a problem by running a DTS package from a stored procedure :
I have no error id, the execution seems to be OK but when I check to see ik the export was ok, nothing has happened.

Here is my code,
When I run the DTS from sql enterprise manager, it is OK but when I use Transact SQL it fails

Thanks in advance,

EXEC @hr = sp_OACreate 'DTS.Package', @oPKG OUTPUT
IF @hr <> 0
BEGIN
PRINT '*** ALTER Package object failed'
EXEC sp_displayoaerrorinfo @oPKG, @hr
RETURN
END
print @hr

EXEC @hr = sp_OAMethod @oPKG,
'LoadFromSQLServer("myserver", " ", " ", 256, , , , "LOTAO2")',NULL
IF @hr <> 0
BEGIN
PRINT '*** Load Package failed'
EXEC sp_displayoaerrorinfo @oPKG, @hr
RETURN
END

--Executing the Package:
EXEC @hr = sp_OAMethod @oPKG, 'Execute'
IF @hr <> 0
BEGIN
PRINT '*** Execute failed'
EXEC sp_displayoaerrorinfo @oPKG , @hr
RETURN
END
ELSE
PRINT '*** Execute OK'

--Cleaning up:
EXEC @hr = sp_OADestroy @oPKG
IF @hr <> 0
BEGIN
PRINT '*** Destroy Package failed'
EXEC sp_displayoaerrorinfo @oPKG, @hr
RETURN
END