I created ssis pakage & save it as a dtsx package in my local drive. so when I execute it from the local drive , it works successfully.

but I need to schedule this as a job in the management studio. But when i run the scheduled job, I get the following error.

"the job failed. the job was invoked by the user sa. last step to run was step1"

"Executed as user MASGRP\wimalp. the command line arguments are invalied. the step failed."

what would be the problem here ?

 Thanks

wimal

Hi Dinesh

This ssis package is related to the excel file what we discussed last time.
I have store the dtx package & the excel files used for this package are, stored in a MAP Drive.

I scheduled this package to run under "sa" account.

also I have added the package as file system.

So if possible, can you just send me the steps I need to follow ?

may be i am following a wrong method.