I need to know if have error when return from DTS called by SP.
I write exec @rc = sp_OAMethod @objPackage, 'Execute' in this case @rc get the 0 value all the time even if the DTS not run correctly. if i add after 'Execute' another parameter with OUTPUT like saw in BOL i get all the time error even if the DTS run ok...
i cant achieve the right syntax to know if have error when have and if not when havent. I use ver 7.0 of MSSQL-SERVER.
Thank you