SOLUTION:

I am running Norton AV. When I attempt to run (manually) the package that creates a file system object, I am prompted by NAV. The prompt informs me...

Actually, I've narrowed it down. My package creates a FileSystem object, and that's where my problem lies. When I run the package, I run it as myself and...

<QUOTE>

Have you tried running the job directly from EM or executing the statement in your earlier posting in Query Analyzer? If so, what are the results there?

<SNIP>

Yes on both accounts....

OK. Here's the config:

I'm using Windows authentication, and my login is the DBO account. I have the SQL Agent service starting up in my account, and have it...

Right, I've got sp_start_job in my trigger:

EXEC sp_start_job @job_name = 'dts_package'

Current problem:

When I execute the package in SQL EM, it works just fine. So, I delete the contents of...