SSIS package fails as SQL Agent 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 2008 Forums

SSIS and Import/Export (2008)

SSIS package fails as SQL Agent Job

Author

Topic

Saphelp178
Starting Member

14 Posts

Posted - 2012-02-03 : 08:03:37

Hi Guys

I have got a SSIS package which works like a treat under BIDS(with 32bit compilation) and via DTExec GUI utility, however, when running as a job under Management studio via SQL Agent job, it fails give me excel connection error.

- I have got 64 bit server 2008 R2
- I have got 32 bit excel 2010

I have tried to change command line to include 32 bit and all sort of changes to it, but no joy.

Any ideas - Much appreciated.

Sap

Saphelp178
Starting Member

14 Posts

Posted - 2012-02-03 : 08:07:06

Error message

"Microsoft (R) SQL Server Execute Package Utility Version 10.50.2500.0 for 32-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Argument "Excel" for option "connection" is not valid. The command line parameters are invalid. The step failed."

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-02-03 : 09:31:06

are you using DTExec for executing package
if yes, see this

http://visakhm.blogspot.com/2011/12/dtexec-issues-running-ssis-packages-in.html

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Saphelp178
Starting Member

14 Posts

Posted - 2012-02-03 : 11:02:48

Hi Visakh

Thanks for your reply.

Ideally i would like to run as job it works fine under DTExec.

I get the above error when running it as a job.

Sap

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-02-03 : 11:13:29

did you enable 32 bit running options and also made sure you called 32 bit version of DTExec as suggested in link?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Saphelp178
Starting Member

14 Posts

Posted - 2012-02-03 : 11:39:57

Hi Visakh

Am I missing a point here??

I am running via job from management studio. Does it involve DTExec utility at all.

Really sorry if i am wrong.

Sap

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-02-03 : 11:57:27

quote:
Originally posted by Saphelp178

Hi Visakh

Am I missing a point here??

I am running via job from management studio. Does it involve DTExec utility at all.

Really sorry if i am wrong.

Sap

you can still call package using DTExec utility from job.
I dunno how you're doing thats why i was checking
Even while you set job property you can check command tab in job step it will be forming DTEXec statement only on the backend

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources