BUG: DTS Designer Might Send an Attention Signal Before SQL Task Completes (271564)

The information in this article applies to:

Microsoft SQL Server 7.0

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 ("Execute SQL Task" 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"exec mysp"
```

STATUS

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

Modification Type:	Major	Last Reviewed:	10/16/2002
Keywords:	kbBug KB271564