DTS package - passing values at run time
Hi,
I am new to sql server. I used the DTS package in sql server 2000 to export data into excel from the database. For this I used the export data wizard option, and included a simple query something like this -
Select name from table where table.id = X.
I saved the package. It's running fine.
I want to pass values to X at run time, i.e. when I execute the saved DTS package it should ask for the value X and based on that value the sql query should run and export data into the excel.
Please let me know how to use global variables and parameters to achieve this.
Please explain in detail, I don't know the other features in DTS.
Thanks,
Krish.
|
