[font="Verdana"]i have similar issue, a store procedure was called from ETL Packages.

when executed store procedure alone warning was shown on result window but executing from pacakges was failed due to this warning.

To resolve we have add Set ANSI_WARNINGS OFF

That is actually the default on SQL 2008 and 2012[/font].