Hi All

I created a DTS package with parameter(s) that reads from a number of SQL Server production tables and writes into an excel file but how can I allow the users to specify the parameter value when opening the excel file, without using Microsoft Query from Excel. Any ideas?