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]]