DTS Running Until Non Stop

Jane · February 28th, 2004, 08:59 AM

I have a table A as this

item amt
A100 20.00
A101 21.00
A102 24.00

then I use this table to sumup using SQL Command as this

select 'TOTAL' as item,sum(amt) as amt
from table A

and my result on my table A as this

item amt
A100 20.00
A101 21.00
A102 24.00
TOTAL 65.00

my While the DTS running a task until sumup SQL command, the DTS cannot sucessfully completed, why it happen, what can i do for the problem as above?

Jane · February 29th, 2004, 02:05 AM

error again :

[Microsoft][ODBC SQL Server Driver]Unknown token received from SQL Server
[Microsoft][ODBC SQL Server Driver]Protocol error in TDS stream
[Microsoft][ODBC SQL Server Driver]Protocol error in TDS stream
[Microsoft][ODBC SQL Server Driver]Protocol error in TDS stream
[Microsoft][ODBC SQL Server Driver]Protocol error in TDS stream
[Microsoft][ODBC SQL Server Driver]TDS buffer length too large
[Microsoft][ODBC SQL Server Driver]TDS buffer length too large
[Microsoft][ODBC SQL Server Driver]Unknown token received from SQL Server
[Microsoft][ODBC SQL Server Driver]Unknown token received from SQL Server
[Microsoft][ODBC SQL Server Driver]Unknown token received from SQL Server
[Microsoft][ODBC SQL Server Driver]Unknown token received from SQL Server
[Microsoft][ODBC SQL Server Driver]Unknown token received from SQL Server
[Microsoft][ODBC SQL Server Driver]Unknown token received from SQL Server

joefawcett · February 29th, 2004, 05:21 AM

You seem to have a lot of trouble with DTS in general and they are hard enough to debug locally, even more so on a web forum. If you are using SQL Server 2000 export the stored procedure to VB 6 and post the code here. I will set it up on my machine and see if mine errors the same.

--

Joe