I just created a very simple SSIS package to retreive data from Oracle to SQL
Server. I saved this package as a single file. I double click to open this
package to execute, it works fine with no error.

And then I created a new job in Management Studio for this package. I set
the owner to be Administrator. I made a new STEP to include this package for
execution.

As I try to run this job, it reports error on running the STEP. In history I
found the following message, can you help me to solve it? Thanks so much!

Date 2005-11-24 17:03:09
Log Job History (Test)

Step ID 1
Job Name Test
Step Name Ess
Duration 00:00:02
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

Message
Executed as user: HAIYAN-Z0QBWY0M\SYSTEM. The package execution failed. The
step failed.

Ok so it works interactively and it fails when scheduled. This most
definitely sounds like a permissions issue. Have you got logging
enabled in the SQL Server package?

"Felix_Jiang" <FelixJiang (AT) discussions (DOT) microsoft.com> wrote