Microsoft KB Archive/271564

= BUG: DTS Designer Might Send an Attention Signal Before SQL Task Completes =

Article ID: 271564

Article Last Modified on 10/16/2002

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q271564



BUG #: 58258 (SQLBUG_70)



SYMPTOMS
When a Data Transformation Services (DTS) package finishes running, the package sends an Attention signal to Microsoft SQL Server and then disconnects. If a SQL Server task (&quot;Execute SQL Task&quot; in the DTS Designer) returns error messages, the DTS Designer sometimes sends an Attention signal before the task completes. The Attention signal may cause the SQL Server task to fail to complete. However, the SQL Server Enterprise Manager shows the task as completing successfully.



WORKAROUND
To work around this behavior, use one of the following methods:  Modify the Transact-SQL code to prevent errors from occurring initially.

-or-

  In the DTS package use Execute Process Task instead of using Execute SQL Task to run either an OSQL command line or a batch file that contains an OSQL command line like the following: osql -SServerName -Usa -P -dpubs -Q&quot;exec mysp&quot; 



STATUS
Microsoft has confirmed this to be a problem in SQL Server 7.0.

Keywords: kbbug kbpending KB271564

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.