FIX: DTS Query Designer Does Nothing When ENTER Key Is Pressed

Data Transformation Services (DTS) allows a user to construct a SQL query for an Execute SQL task. However, there is no effect when the ENTER key is pressed in the SQL pane of the Data Transformation Services Query Designer. That is, the cursor is not moved to the next row, nor is a new line inserted.

To work around this problem, either hold down the Control key while you press ENTER or do the following:

1. Write the SQL query in a text editor, such as Notepad.
2. Cut and paste the query from the text editor to the SQL pane of the Data Transformation Services Query Designer window.

Microsoft has confirmed this to be a problem in SQL Server 7.0. This problem has been corrected in U.S. Service Pack 1 for Microsoft SQL Server 7.0. For more information, click the following article number to view the article in the Microsoft Knowledge Base: For more information, contact your primary support provider.

To view the SQL pane of the Data Transformation Services Query Designer window, do the following:

1. Start SQL Server Enterprise Manager.
2. Open the Data Transformation Services folder.
3. Create a new package or Design an existing package.
4. In the DTS package window, create a new Execute SQL Task (on the Task menu, click Execute SQL Task).
5. Right-click the Execute SQL Task and click Properties on the shortcut menu.
6. In the Execute SQL Properties window, click the Build Query button.
7. Click the cursor to the lower-right pane of the Data Transformation Services Query Designer window. This is the SQL pane of the window. Pressing the ENTER key in the SQL pane does not move the cursor to the next row in the pane.