I needed to create a job that would export a table from one database into a database on another server. I right clicked on my table name and selected all tasks then export data, and executed and saved the package, now I can not find the package and did not find the option to schedule when it was to execute.

Where can I find the package that I saved in Server Manager and set it up as a job so it can be scheduled?

Thanks.

I figured it out. I didn't realize that you can't see where they are stored and have to create a new job then select Integration Services.

Now my problem is that when I manually do the steps it runs successfully but when trying to schedule the package to execute it fails with the following error message:
Executed as user: SQL01\SYSTEM. The package execution failed. The step failed.

Did you figure out what is causing this error ?

I'm getting the same failure running a package as a job

No, I never solved it. I'm wondering if it has to do with one of the servers is using SQL Server 2000 and the other is 2005. It could also have something to do with permissions not being correctly set. I've just been manually running the import/export as the priority has decreased.