By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,963 Members | 1,834 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,963 IT Pros & Developers. It's quick & easy.

User initializes variable through VB in a DTS package? Is it possible?

antonopn
P: 42
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!
May 14 '08 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.