Hi,
Thank for your help.
I need to export data from a sql table to a excel file but in the query I
want to use parameters (start date and finish date) and this values I need
change. (prompt me to type)

I try to use global variables but this do not accept in the query (Execute
Sql task)

Regards.

Which version of DTS are you using?

You do not want the ExecuteSQL task you want the Transform Data Task.

Your Source Query will look something like

SELECT <col list> FROM <Table> WHERE <col> BETWEEN ? AND ?

You then click the parameters button and map the ? to Global Variables



"Gualberto" <gfranco (AT) info-arch (DOT) com> wrote

Thank you.
I am new in this.



"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote