Hello there!
I'm really confused about this! I have created a project (DTS in SQL SERVER 2000) which imports a txt file and runs some SQL statements. I want the user who runs it each time to initialize a variable, which is a sql variable (ex. @userdate). I 've been thinking using an Active X script inside the DTS and when the DTS is executed, a form (or something) will come up and the user will set the variable value (this is a datetime value).
Can you PLEASE HELP ME?
THANKS IN ADVANCE!
I'm really confused about this! I have created a project (DTS in SQL SERVER 2000) which imports a txt file and runs some SQL statements. I want the user who runs it each time to initialize a variable, which is a sql variable (ex. @userdate). I 've been thinking using an Active X script inside the DTS and when the DTS is executed, a form (or something) will come up and the user will set the variable value (this is a datetime value).
Can you PLEASE HELP ME?
THANKS IN ADVANCE!