Help me Error SSIS Error (Agent Service)

Question

Post reply

Help me Error SSIS Error (Agent Service)

mai0165

Old Hand

Points: 337
More actions
January 9, 2013 at 2:49 am

#269081

An invalid reporting option was specified. Only E, W, I, C, D, P, V, and N are allowed
Import Data Source from Oracle to SQL Server2008
password Oracle have '['
how solution
thanks

Viewing 6 posts - 1 through 5 (of 5 total)

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

Gary Varga SSC Guru Points: 82166 More actions · Answer 1

Perhaps you can post the failing command? That would help anyone see what the problem is.

Gaz

-- Stop your grinnin' and drop your linen...they're everywhere!!!

mai0165 Old Hand Points: 337 More actions · Answer 2

I have run ssis package by agent service.

it error (another package no error) T T

thanks

Gary Varga SSC Guru Points: 82166 More actions · Answer 3

What are the settings used? Any parameters etc ?

Gaz

-- Stop your grinnin' and drop your linen...they're everywhere!!!

mai0165 Old Hand Points: 337 More actions · Answer 4

The tests showed that error password of oracle source

this connection string of Oracle

Data Source=ptcdw;User ID=nfctp;Password=dkig'bo_ptc;Provider=MSDAORA.1;Persist Security Info=True;

because password has '

this error message

Step ID1

ServerWIN-LGEV2QOJN58

Job Nametest

Step NameTest1

Duration00:00:01

Sql Severity0

Sql Message ID0

Operator Emailed

Operator Net sent

Operator Paged

Retries Attempted0

Message

Executed as user: WIN-LGEV2QOJN58\SYSTEM. Microsoft (R) SQL Server Execute Package Utility Version 10.50.1600.1 for 64-bit Copyright (C) Microsoft Corporation 2010. 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.

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

mai0165 (1/15/2013)
The tests showed that error password of oracle source
this connection string of Oracle
Data Source=ptcdw;User ID=nfctp;Password=dkig'bo_ptc;Provider=MSDAORA.1;Persist Security Info=True;
because password has '
this error message
Step ID1
ServerWIN-LGEV2QOJN58
Job Nametest
Step NameTest1
Duration00:00:01
Sql Severity0
Sql Message ID0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted0
Message
Executed as user: WIN-LGEV2QOJN58\SYSTEM. Microsoft (R) SQL Server Execute Package Utility Version 10.50.1600.1 for 64-bit Copyright (C) Microsoft Corporation 2010. 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.

The error is complaining about the command line options used to run the package, not about an Oracle password. See the documentation for DTEXEC and check out the /Rep(orting) switch.

How did you schedule the package in the Agent job?

edit: I also fail to see how this question is even remotely connected to PowerShell...

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