john.brees (8/14/2014)
Hello, I would be grateful if anyone could help me. I have to modify an SSIS package that someone else has written that prompts the user for a variable using the code below.
Wait, whut? This is quite possibly the worst use of SSIS you can do. SSIS is meant for automation behind the scenes and was never intended for user interfacing. This is why you're running into such significant problems trying to do it. It'll fight you every step of the way.
Yes, like everything else it can be done. You're opening up a can of worms you don't realize yet though if you try.
Are you willing to back this discussion up a bit? What is the purpose of this SSIS package and user interface? Maybe we can give you something a lot more friendly to attempt to implement.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA