• 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