helo all,
i hv created a DTS package to download data from my table.and i am calling the package from my stored procedure.
when i m using "select * from <my_table>" in my package ,its doing well.
but now i want 2 pass 2 parameter s to my DTS package from my ASP page which will be user inputs.and based on the parameter i will fire d query
(select * from <my_table> where <my_column> between <param1 > and <param2>.
i think the "global variables" of DTS will be used somehow.but not sure how to pass parameters from my page
PLZ help.
regards,
Lipsa
i hv created a DTS package to download data from my table.and i am calling the package from my stored procedure.
when i m using "select * from <my_table>" in my package ,its doing well.
but now i want 2 pass 2 parameter s to my DTS package from my ASP page which will be user inputs.and based on the parameter i will fire d query
(select * from <my_table> where <my_column> between <param1 > and <param2>.
i think the "global variables" of DTS will be used somehow.but not sure how to pass parameters from my page
PLZ help.
regards,
Lipsa