DTS Error "Execution cancel by user"
-
i have a DTs that has steps, collecting info from Different tables and recreate a temp table for reporting. When i execute this DTS that has steps, i get the Error
"Execution Canceled by user"
and i did not cancel it. Please help
Vuyiswa Maseko, Sorrow is Better than Laughter, it may Sudden your Face, but It sharpens your Understanding VB.NET/SQL7/2000/2005 http://vuyiswamb.007ihost.com http://Ecadre.007ihost.com vuyiswam@tshwane.gov.za
-
i have a DTs that has steps, collecting info from Different tables and recreate a temp table for reporting. When i execute this DTS that has steps, i get the Error
"Execution Canceled by user"
and i did not cancel it. Please help
Vuyiswa Maseko, Sorrow is Better than Laughter, it may Sudden your Face, but It sharpens your Understanding VB.NET/SQL7/2000/2005 http://vuyiswamb.007ihost.com http://Ecadre.007ihost.com vuyiswam@tshwane.gov.za
IF you are able to execute the DTS package manually using dtsrun.exe , then the problem relates to a bug addressed here http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q319058&[^] Then see the workaround methods in the clickity above! Cheers Raz
/* Ghazi Hadi Al Wadi, PMP, ASQ SSGB, DBA */
-
IF you are able to execute the DTS package manually using dtsrun.exe , then the problem relates to a bug addressed here http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q319058&[^] Then see the workaround methods in the clickity above! Cheers Raz
/* Ghazi Hadi Al Wadi, PMP, ASQ SSGB, DBA */
Thanks it worked for me
Vuyiswa Maseko, Sorrow is Better than Laughter, it may Sudden your Face, but It sharpens your Understanding VB.NET/SQL7/2000/2005 http://vuyiswamb.007ihost.com http://Ecadre.007ihost.com vuyiswam@tshwane.gov.za
-
Thanks it worked for me
Vuyiswa Maseko, Sorrow is Better than Laughter, it may Sudden your Face, but It sharpens your Understanding VB.NET/SQL7/2000/2005 http://vuyiswamb.007ihost.com http://Ecadre.007ihost.com vuyiswam@tshwane.gov.za
HTH! Raz
/* Ghazi Hadi Al Wadi, PMP, ASQ SSGB, DBA */