SQL Server Performance

Using Output Variables from a Stored Proc in DTS

Discussion in 'SQL Server DTS-Related Questions' started by jaswinder1974, Aug 26, 2004.

  1. jaswinder1974 New Member


    I am trying to assign values to some global variables from stored procedure output variables.

    If I declare sp like:

    DECLARE @RC int
    DECLARE @FileName varchar(255)
    DECLARE @PackageName varchar(100)
    DECLARE @DestinationTableName varchar(100)
    DECLARE @ReturnValue int

    EXEC @RC = [Swapsback].[dbo].[sp_InitialisePackageExecution] ?, ?, @FileName OUTPUT , @PackageName OUTPUT , @DestinationTableName OUTPUT , @ReturnValue OUTPUT

    I am getting syntax error or access violation error.

    any ideas?

    Jaswinder Singh
    A K ITech Limited
    London, UK
  2. Argyle New Member

Share This Page