SQL package fails when run from Job

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

SQL package fails when run from Job

Author

Topic

srivatsahg
Yak Posting Veteran

71 Posts

Posted - 2009-09-30 : 04:41:53

Hello all

I have created a SQL package which does the exporting of customized views in my database to a CSV file format. It runs smooth from VisualStudio from where i had created this package. However since i want to automate this operation, i added this as a SQL server agent job.

But when i do this, the package always fails. I know this issue is something related to the issue w.r.t permissions.

The event log in job history :
Executed as user MACHINENAME\SYSTEM. The command line parameters are invalid. The step failed.

Can anyone guide me in this direction.

Regards
Srivatsa

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-09-30 : 12:53:16

Could you show us the command line parameters?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

srivatsahg
Yak Posting Veteran

71 Posts

Posted - 2009-10-02 : 03:39:20

Hello Tara

I am not using any command line parameters.
May be this might be an issue. The package i run doesnt expect any command line parameters when i run from Visual Studio.
Does it need when run from SQL agent jobs ???

Thanks
Srivatsa

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources