Post reply

sp_OAMethod

  • March 23, 2006 at 3:12 pm

    #365583

     Trying to execute the Stored procedure with the following statment

    -- Call the load method on the DTS Package object pass the path

    EXEC

    @HRESULT = sp_OACreate 'DTS.Package', @DTSPackageObject OUTPUT

    EXEC @HRESULT = sp_OAMethod @DTSPackageObject, 'LoadFromSqlServer', Null, @ServerName='XYZ', @packagename='\PkgFolder\DataUpload', @flags=256

    Getting the following error

    The specified DTS Package ('Name = '\PkgFolder\DataUpload'; ID.VersionID = {[not specified]}.{[not specified]}') does not exist.

    I am executing the SP from Query Analyzer and using SQL Server 2005. As noticed I am using windows authentication. I can execute this package using dtexec /SQL pkgfolder\Dataupload on the command window of sql server 2005 with out any problem. Any help is greatly appreciated. 

    For that matter I am not able to execute any package from the stored proc. I am getting the same error.

     

    Thanks. 

  • March 27, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • March 27, 2006 at 9:12 am

    #628953

    Try using the full UNC path for the package.  The current drive and current directory for the command window is not necessarily the same as the settings used by sp_OAMethod.

    It also may be a security issue.  sp_OAMethod may run as the SQL Server service login, while a command executed at a command prompt runs with your login credentials.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply