smart_analyst (8/28/2014)
I have created a my first SSIS package where I am using Execute SQL task and trying to run a simple select query.I am using one input variable school_name and trying to display school_no.
There is no UI that displays any results in the Command Flow. The most straight forward way is to create a variable to assign the returned value from your query in the Execute SQL task. Then use a MessageBox in a script task to display the value.
Task gets executed with one error but it doesn't fail.
The error exception is configurable to a certain extent within SSIS.
😎
BTW: I recommend you have a look at Stairway to Integration Services[/url].