Help me Error SSIS Error (Agent Service)

  • 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

  • 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!!!

  • I have run ssis package by agent service.

    it error (another package no error) T T

    thanks

  • What are the settings used? Any parameters etc ?

    Gaz

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

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

  • 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

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

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