How to access the Query Designer in Data Transformation Services (Enterprise Manager)

To access the Query Designer in Data Transformation Services

1. Right-click on an Execute SQL Task object and select Properties.
2. In the Execute SQL Properties window, click Build Query.

The Query Designer will open with the diagram and SQL panes visible. To open panes, see How to open panes in the Query Designer (Enterprise Manager).

Note There must be a valid data source connection in the package to build a query. If there is not, a connection must be created before trying to access the Query Designer.