Results not changing

[unclerico]

Windows 2003 Server SP1
SQL 2000 SP4

I have a DTS Package that is three steps:
1) Make the connection to the local SQL Server
2) Query the database (Execute SQL Task)
3) Output the results of the query to a text file (ActiveX Task)

In the SQL Task I have the following:

CODE
SELECT [who], [what], [when]
FROM tblLogger
WHERE [when] = ?
[/code]
and this is where I define two global variables; gInputValue (input variable), gResults (output variable).

In the ActiveX task I create a text file and loop through the gResults variable and output the results.

I have an ASP.net page that executes the DTS Package and assigns the value the end user supplies to the gInputValue global variable.

Everything is peachy except that the results being output never change, no matter what gInputValue I provide it. At the top of the text file that is created I write the value of gInputValue and it is what I provided via the .net app. Of course if I hard code a date value in the query and remove the gInputValue parameter it works fine. I am banging my head on anything solid that I can find, but it isn't working. Does anyone have insight into what is happening and why?? Thanks.

 

[unclerico]

My source connection in the DTS package was originally set to use Windows Authentication, I ended up creating a SQL user and voila, everything works as needed. Thanks for your help