DTS fails on Stored Procedure warning

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mo - 22 Aug 2005 20:19 GMT

Hi,
I am calling a stored proc from a DTS package in SQL 2000 using Execute SQL
step & when I try to execute it from DTS, I get 'failed on execution', but
when I run the stored proc manually, it runs fine, but gives a couple of
warnings:
Warning: Null value is eliminated by an aggregate or other SET operation.
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.

Any ideas why this happens?
Thanks,
Mo

Reply to this Message

Jéjé - 24 Aug 2005 01:54 GMT

you can setup an option when you call a dbcc command
generally there is a "no_msg" (or an option like this; read the BOL) which
disabled output except in case of errors.

> Hi,
> I am calling a stored proc from a DTS package in SQL 2000 using Execute
[quoted text clipped - 9 lines]
> Thanks,
> Mo

Reply to this Message