DTS package doesn't execute

[mychevworld]

I'm pulling my hair out. After several attempts I got the sp_OAMethod
to execute without error. Unfortunately the DTS package isn't
executing. It also isn't returning any error. What could I be doing
wrong? Any help would be appreciated.

This is the
EXEC @hr=sp_OACreate 'DTS.Package', @oPKG OUTPUT
IF @hr<>0
BEGIN
EXEC sp_OAGetErrorInfo @oPKG,@src OUT, @desc OUT
SELECT hr=convert(varbinary(4),@hr), Source=@src, Description=@desc

RAISERROR (@desc,16,1)
RETURN

END

EXEC @hr=sp_OAMethod
@oPKG,'LoadFromSQLServer',NULL,@ServerName='CAMDEV 0',@PackageName='TestPkg',@Flags=256
IF @hr<>0
BEGIN
EXEC sp_OAGetErrorInfo @oPKG,@src OUT, @desc OUT
SELECT hr=convert(varbinary(4),@hr), Source=@src, Description=@desc

RAISERROR (@desc,16,1)
RETURN
END

--Execute the pkg
EXEC @hr=sp_OAMethod @oPKG,'Execute'
IF @hr<>0
BEGIN
EXEC sp_OAGetErrorInfo @oPKG,@src OUT, @desc OUT
SELECT hr=convert(varbinary(4),@hr), Source=@src, Description=@desc
print @desc
RAISERROR (@desc,16,1)
RETURN
END

[Simon Hayes]

Your code runs a package correctly when I tried it, but I suspect
there's probably an error within the package itself - it's being
Executed correctly, but then one particular step is failing. I would
enable package logging and an error file (if you haven't already), and
see what that shows.

Since DTS is client-side, even if you've tested the package
successfully from your workstation in EM, there may be problems when
you execute it from the server:

http://support.microsoft.com/default...b;en-us;269074

Simon