I'm new to using DTS. I have a package that contains an ActiveX Script Task
that sets two global variables (date1 and date2). I now need to retrieve a
record from an sql2000 database that contains a date value to use in
comparison. I'm use to msAccess and would typically use a DLOOKUP to get
this. How do I retrieve and set a variable to this retrieved value? I was
thinking of creating another ActiveX Script Task using ado but I'm not sure
if this is possible or the way to go? Any suggestions.

Thanks in advance

Hello Franky,


If what you want to do is retrieve a value from a SQL Server 2000 server
by issuing a query and store the returned value in a variable. You can then
use this variable in a parameterised statement then you can have a look here
at this

http://www.sqldts.com/default.aspx?205

You can grab the value from your Query by using an ExecuteSQL task and hitting
the Parameters button



Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com