Hello,
I am trying to set up a DTS Export on SQL 2000 that will export a query but I get a "Puntero no es valido" or "Curson not Valid" error.
The query code works fine when I run it on it own and provides the results in the table.
It only gives the error when I run the same query in the DTS process.
Here is my query ...
delete ConsumoClientes3
Insert Into ConsumoClientes3
Select
Cliente as AccountNumber,
Convert (varchar(10),Fecha,103) AS HistoricalDate,
Sum(Segundos)/60 As Minutes,
CONVERT(varchar(100), CAST(SUM(Total) AS decimal(38,4))) as Charges,
CONVERT(varchar(100), CAST(Sum(Coste) AS decimal(38,4))) as Cost,
CAST (Cliente as varchar) + Convert (varchar(10),Fecha,112) AS AutoID
From
Historico
Where
Fecha between getdate()-4 AND getdate()
Group By
Cliente,Convert (varchar(10),Fecha,103),Convert (varchar(10),Fecha,112),Cast (Cliente as varchar) + Convert (varchar(10),Fecha,112)
Order By
Cliente
delete ConsumoClientes3Export
Insert Into ConsumoClientes3Export
SELECT ConsumoClientes3.AccountNumber as AccountNumber,
ConsumoClientes3.HistoricalDate AS Historical_Date,
ConsumoClientes3.Minutes As Minutes,
ConsumoClientes3.Charges as Charges,
ConsumoClientes3.Cost as Cost,
ConsumoClientes3.AutoID AS AutoID,
ClientesSFID.AccountSFID AS Account
FROM ClientesSFID INNER JOIN ConsumoClientes3 ON ClientesSFID.AccountNumber = ConsumoClientes3.AccountNumber
WHERE HistoricalDate between getdate()-5 and getdate()
ORDER BY AutoID ASC;
select * from ConsumoClientes3Export
Any help is greatly appreciated.
thanks
Puntero no valido - Cursor not Valid error DTS
Posted - 2011-03-18 : 06:39:33
