I'm using a DTS package to move data from one database to another, as you do.
The Transform Data task between the two connections uses a SQL statement which includes a hardcoded date variable in the criteria.
" where entrydate = '31 Oct 2003' "
Is there anyway to pass a parameter or variable to the dts package, like you can to a stored procedure?
I thought of having another statement to get a datevalue from another table, but DTS doesn't seem to like multiple sql statements in the Transform Data Tasks.
My last resort option is to use the getdate() function, but this would reduce my flexibility too much.
Theres a couple of steps for this I don't understand.
Should the tasks in the process be as follows?:
1: ActiveX script task to
get the date value from a table using sql, and saves it as a globalvariable 'Var1'?
2: Transform Data task which uses global variable 'Var1' in the sql statement?
How do you use sql in the ActiveX task?
And how do you reference the global variable in the Transform data sql statement?