This is exactly why I love this site. I was getting the same error from copying a query from QA to my DTS package. Placed these two commands at the beginning of my DTS query:
SET NOCOUNT ON
SET ANSI_WARNINGS OFF
and viola' it works!
Thanks for the solution.
Clarence