Hi,
could neone plz guide me as how to get the exact error when job/step fails.
My package runs fine in development but fails when executed as a job. The
error gives no specific info. I want to enable log so that atleast I get a
proper error info to work on.

Error :
Executed as user: mydomain\sqladmin. The package execution failed. The step
failed.

regards,

It's probably a permissions issue then. Even though this is for DTS the
principle is the same so have a look:


http://www.support.microsoft.com/?id=269074
http://support.microsoft.com/default...b;en-us;890775


--
Andrew J. Kelly SQL MVP


"k_s" <ks (AT) discussions (DOT) microsoft.com> wrote