How to access the Query Designer in Data Transformation Services (Enterprise Manager)
To access the Query Designer in Data Transformation Services
- Right-click an Execute SQL Task object, and then click Properties.
- 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 Query and View Designer Layout.
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.