December 16, 2011 at 7:59 am
Hello All,
I have a requirement like this.When someone executes my ssis package, I want the user to be prompted to fill in a few parameters. How do i do that?
Thanks
December 16, 2011 at 9:19 am
srik.kotte (12/16/2011)
Hello All,I have a requirement like this.When someone executes my ssis package, I want the user to be prompted to fill in a few parameters. How do i do that?
Thanks
Are they going to run the actual SSIS package (in design mode) from BIDS? In that case, you could try an inputbox in a script task (http://msdn.microsoft.com/en-us/library/microsoft.visualbasic.interaction.inputbox(v=vs.80).aspx#Y71). Don't know if it will work, as I haven't tried it before.
The above would not be the ideal way though...you would be better off developing something like a simple asp.net page (or something similar), and passing the parameters to the SSIS package from that.
December 16, 2011 at 12:48 pm
Not from BIDS. I want something like that in sql agent.
December 16, 2011 at 12:55 pm
srik.kotte (12/16/2011)
Not from BIDS. I want something like that in sql agent.
SQL Agent is a scheduling tool only...not a development platform. You cannot create components for user interaction (like inputboxes) in SQL Agent.
December 19, 2011 at 5:34 am
Martin Schoombee (12/16/2011)
srik.kotte (12/16/2011)
Not from BIDS. I want something like that in sql agent.SQL Agent is a scheduling tool only...not a development platform. You cannot create components for user interaction (like inputboxes) in SQL Agent.
To expand further, SSIS is also not really meant to be user interactive.
If you really want to do it, create a .NET app that asks the input from the users and then kicks off the package using DTEXEC command line utility and the /SET switch to set the parameters.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply