What are you trying to achieve?  In a sql script, you have local variables that you can use if writing a stored procedure.

The dts should be set up this way:

Connection1--->Connection2--->ActiveX--->Send Mail Task

And this is what should be in the ActiveX Script:

Function Main()

 dim conn, rs

 set conn = CreateObject("ADODB.Connection")

 set rs = CreateObject("ADODB.Recordset")

 DSN1 = "Provider=sqloledb;"...

If I understand what you're asking:

You want to be able to manipulate a Date global Variable to where you can enter in the date (if the date isn't coming from...

This would be a good candidate for an ActiveX Script:

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

Also, you want to put the number of records in a global variable and reference that global variable in the...