I am trying to use a datediff with a parameter in DTS as follows

Select * from dbo.tbl where datediff(dd,ReportDate,?) = 1

I have set it up the global variable in Parameters. If I do preview I get
"No value given for one or more required parameters"
If I run it, it compeltes successfuly only no data is retruned.

Any Ideas?

I would be looking to build this statement up like this

Global Variables and SQL statements in DTS
(http://www.sqldts.com/default.aspx?205)


Allan



"Zach.Baier" <ZachBaier (AT) discussions (DOT) microsoft.com> wrote