schedule package

I am trying to create a job to automatically execute a package.The package was created by use of the wizard.It’s very simple…export a view to a flat file.If I run the package as is it generated the file.However when I create a job and try to run the job it errors out with package cannot be found even though the path of the dtsx file is correct.

Shouldn’t I be able to schedule a package which was created by the wizard?Do you have any idea when I’d get a msg that package cannot be found even though the path is correct?

Please let me know your thoughts on this issue…I am at a lost.

Thanks,

Nats

Did you promote the package to the server where SQL Server Agent exists? (I assume you're using SQL Server Agent)|||Yes I am using SQL Server Agent. What do you mean "promote the package to the server"?|||Well, the package has to be on the server where SQL Server Agent is running.

If you developed the package on your desktop and are using SQL Server Agent on another machine, the package has to be moved to that machine.

If you do have it on the same machine, then you have to be sure that SQL Server Agent has access to the folder/file.|||

The package was save to my desktop...once i moved it out to the server it works fine.

Thanks for the the advise.