We shall, again, be visiting this tab throughout the article but to give you an initial heads up this is where you define the input, output and return values from your task. If however you now move on to the Result Set tab this where you define what variable will receive the output from your SQL Statement in whatever form that is.
Property Expressions are one of the most amazing things to happen in SSIS and they will not be covered here as they deserve a whole article to themselves.
As with SQL Server 2000 DTS, SSIS allows you to output values from this task in a number of formats.
Have a look at the combobox next to the property you will see the ways in which you can pass a SQL Statement into the task itself.
This could then be used by the workflow constraints.
Possible values are None, Success, Failure and Completion.
Bypass Prepare Should the statement be prepared before sending to the connection manager destination (True/False) Connection This is simply the name of the connection manager that the task will use.
One is in the task UI itself and the other is in the property pane which will appear if you right click on your task and select from the context menu.Whilst on the general tab, drop down the combobox next to the property.In here you will see the types of connection manager which this task will accept.We will be doing plenty of property setting in the UI later so let's take a moment to have a look at the property pane. Now we shall take you through all the properties and tell you exactly what they mean.A lot of these properties you will see across all tasks as well as the package because of everything's base structure The Container.