SQL Server Agent Job Fail running an SSIS Package

Question

Post reply

SQL Server Agent Job Fail running an SSIS Package

keng_mkt

Old Hand

Points: 355
More actions
September 6, 2015 at 10:36 pm

#300341

[font="Tahoma"]Hi Everybody,
I've got a SSIS package installed on a SQL Server 2012
and setting ProtectionLevel is "EncryptSensitiveWithPassword" .
If I run the SSIS package manually, it works.
If I run it using dtexec, it works.
If I create a SQL Agent job with a single step to run the package, it fails.
Error message
Executed as user: XXXXXXXXXX\SYSTEM. Microsoft ® SQL Server Execute Package Utility Version 11.0.2100.60 for 64-bit Copyright © Microsoft Corporation. All rights reserved. An invalid reporting option was specified. Only E, W, I, C, D, P, V, and N are allowed. The command line parameters are invalid. The step failed.
Thanks in advance, KENG[/font]

Viewing 8 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Eirikur Eiriksson SSC Guru Points: 182948 More actions · Answer 1

Eirikur Eiriksson

SSC Guru

Points: 182948

September 6, 2015 at 11:53 pm

#1824897

Post the full configuration for the agent job.

😎

Koen Verbeeck SSC Guru Points: 259197 More actions · Answer 2

Eirikur Eiriksson (9/6/2015)
Post the full configuration for the agent job.
😎

More specifically, whatever you find in the "command line" tab of the agent job step.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

keng_mkt Old Hand Points: 355 More actions · Answer 3

In Command line tab

/FILE "\"C:\Users\Administrator\Documents\Visual Studio 2010\Projects\SSIS_KENG_TEST4_86_TO_21\SSIS_KENG_TEST4_86_TO_21\Package.dtsx\"" /DECRYPT /CHECKPOINTING OFF /REPORTING E

Eirikur Eiriksson SSC Guru Points: 182948 More actions · Answer 4

keng_mkt (9/7/2015)
In Command line tab
/FILE "\"C:\Users\Administrator\Documents\Visual Studio 2010\Projects\SSIS_KENG_TEST4_86_TO_21\SSIS_KENG_TEST4_86_TO_21\Package.dtsx\"" /DECRYPT /CHECKPOINTING OFF /REPORTING E

Quick question, can the SQL Server Agent access the Administrator's home directory?

😎

Suggest you read this article: Setting Up Your SQL Server Agent Correctly[/url]

Koen Verbeeck SSC Guru Points: 259197 More actions · Answer 5

Eirikur Eiriksson (9/7/2015)
keng_mkt (9/7/2015)
In Command line tab
/FILE "\"C:\Users\Administrator\Documents\Visual Studio 2010\Projects\SSIS_KENG_TEST4_86_TO_21\SSIS_KENG_TEST4_86_TO_21\Package.dtsx\"" /DECRYPT /CHECKPOINTING OFF /REPORTING E
Quick question, can the SQL Server Agent access the Administrator's home directory?[/b]

+1

Either change the directory so you can test this, or use a proxy account in your SQL Agent job step.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

keng_mkt Old Hand Points: 355 More actions · Answer 6

hello

I’ve already change to another directory and use another proxy account.

But it still get same error. So I have no idea to fix it.

Can anyone help?

Koen Verbeeck SSC Guru Points: 259197 More actions · Answer 7

keng_mkt (9/24/2015)
hello
I’ve already change to another directory and use another proxy account.
But it still get same error. So I have no idea to fix it.
Can anyone help?

Do you get the same error if you recreate the step?

Do you specify any variables in the Agent job step?

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP