Problems with DTS

[fernan]

Hi this is my first post. Sorry for my English, I speak Spanish.
Well I have a problem with a DTS.
I want to execute a query and then insert the results on another table.
This is the query:
SELECT
S.STRMVK_ARTCOD,
P.STMPDH_DESCRP,
S.STRMVK_TIPPRO,
SUM(S.STRMVK_STOCKS) AS CANTIDAD
FROM
STRMVK S INNER JOIN STMPDH P ON S.STRMVK_ARTCOD = P.STMPDH_ARTCOD
WHERE
(S.STRMVK_TIPPRO = 'TERMIN' OR
S.STRMVK_TIPPRO = 'RPTOSE' OR
S.STRMVK_TIPPRO = 'ACCRS') AND
(P.STMPDH_DESCRP <> '*')
GROUP BY
S.STRMVK_ARTCOD, P.STMPDH_DESCRP, S.STRMVK_TIPPRO

The destination table has the same structure as the query results.
When I run the DTS package, shows me that that the task failed.
The error file say this:

Package Name: (null)
Package Description: (null)
Package ID: {733BA1D2-5281-49D5-A97C-BA0B66802035}
Package Version: {733BA1D2-5281-49D5-A97C-BA0B66802035}
Step Name: DTSStep_DTSDataPumpTask_1
Execution Started: 08/09/2006 11:04:28 a.m.
Error at Destination for Row number 7821. Errors encountered so far in this task: 1.
Execution Completed: 08/09/2006 11:04:28 a.m.

So I don't know what to do. Please if someone helps me, I appreciate.
Thanks.
Fernan.