Database Reference
In-Depth Information
Figure 7-30.
Configuring a connection for an Execute SQL task
The connections available in the dropdown box are context sensitive to the connection type selected in the
ConnectionType property. If the connection type is not set to OLE DB but instead is set to another connection
type such as ADO.NET, any OLE DB connection managers that have been created will not appear in the
dropdown selection. Switching the ConnectionType property to OLE DB allows them to appear (Figure
7-30
).
To add SQL code, you need to configure the SQL Statement property. After clicking this property, you will see
that an ellipsis button appears. When you click the ellipsis button, a dialog appears where you can add your SQL
code (Figure
7-31
). Hidden buttons like this one are becoming commonplace in Microsoft applications. If you do
not immediately see a way to configure a property, try clicking it to see whether it contains a hidden button.
■
in Microsoft's most recent user interfaces, dropdown boxes, buttons, or ellipsis icons do not appear until you
click a property setting. This newer, sexier interface can cause some problems when trying to figure out how a given
property is configured. Just remember; when in doubt, click the property!
Tip
