Example of Parameter in DTS Package

Hi,

Please show me a example of how to create and use a Parameter in DTS Package (SQL Server 2000)

Thanks,

Vivek Gupta

Rather than explicitly pass a parameter to the DTS package to pass to some stored procedure, why not create a a parameter table to pass in the value. Suppose you want to pass in an integer, then create a ParamInt table, with columns of Id (Integer non-identity primary key, ParameterName Varchar(50), ParameterValue Int default value 0.

Insert your value (or values) as rows into this table - you stored procedures run by the DTS package can then pickup their parameters from the appropriate row of this table.

HTH