sp_OAMethod Failure

[bajo71]

Hello,

I have the following to run a DTS package within a stored procedure. I'm using the sp_OA... automation procedures but I seem to get stuck on the following line. Below it is a print of the error message. Thanks for your help.

EXEC @hr = sp_OAMethod @oPKG, 'LoadFromSQLServer("OWS78002878791", "", "", 256, , , , "EVA_Export")'
IF @hr <> 0
BEGIN
EXEC sp_OAGetErrorInfo @object, @src OUT, @desc OUT
PRINT '*** Load Package failed' + ' ' + @desc

RETURN


*** Load Package failed sp_OAMethod usage: ObjPointer int IN, MethodName varchar IN [, @returnval <any> OUT [, additional IN, OUT, or BOTH params]]

 

[AlexCuse]

please don't cross-post in different forums.

thread961-1400110


[small]----signature below----[/small]
I don't do any programming whatsoever

Ignorance of certain subjects is a great part of wisdom