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


am incercat asta si primesc output :error LoadFromStorageFile

pachetul exista si este functional ...