Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Help me Error SSIS Error (Agent Service) Expand / Collapse
Author
Message
Posted Wednesday, January 9, 2013 2:49 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, February 13, 2013 8:20 PM
Points: 3, Visits: 12
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
Post #1404624
Posted Wednesday, January 9, 2013 3:07 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 2:00 AM
Points: 5,327, Visits: 3,014
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!!!
Post #1404639
Posted Wednesday, January 9, 2013 6:56 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, February 13, 2013 8:20 PM
Points: 3, Visits: 12
I have run ssis package by agent service.

it error (another package no error) T T


thanks
Post #1405117
Posted Thursday, January 10, 2013 1:35 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 2:00 AM
Points: 5,327, Visits: 3,014
What are the settings used? Any parameters etc ?

Gaz

-- Stop your grinnin' and drop your linen...they're everywhere!!!
Post #1405255
Posted Tuesday, January 15, 2013 7:00 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, February 13, 2013 8:20 PM
Points: 3, Visits: 12
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 ID 1
Server WIN-LGEV2QOJN58
Job Name test
Step Name Test1
Duration 00:00:01
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

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.
Post #1407543
Posted Wednesday, January 16, 2013 1:03 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:43 AM
Points: 13,605, Visits: 10,486
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 ID 1
Server WIN-LGEV2QOJN58
Job Name test
Step Name Test1
Duration 00:00:01
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

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...




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1407648
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse