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

Article translations Article translations
Article ID: 207451 - View products that this article applies to.
This article was previously published under Q207451
This article has been archived. It is offered "as is" and will no longer be updated.
BUG #: 46568 (SQLBUG_70)
Expand all | Collapse all

SYMPTOMS

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.

WORKAROUND

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.

STATUS

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:
232570INF: How to Obtain Service Pack 1 for Microsoft SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0
For more information, contact your primary support provider.

MORE INFORMATION

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.

Properties

Article ID: 207451 - Last Review: October 11, 2013 - Revision: 2.1
APPLIES TO
  • Microsoft SQL Server 7.0 Standard Edition
Keywords: 
kbnosurvey kbarchive kbbug kbfix KB207451

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com