SQL Server Agent running an SSIS package, and is unable to detect a file path!

  • Scenario:  An SSIS package needs to read a flat file and insert it into the host SQL server DB table.

    Flat file:   Sits in a file folder in windows OS, on another server (file server)

    the flat file manager uses UNC

    VS IDE:     The solution works from within the IDE.

    Service Account:    Is an AD account with full rights on the file folder containing the file

    -----------

    Issue:       The execution fails with an error describing an invalid file path.

    Please find the attached PDF file for more information. Any information is a valuable information 🙂

    Cheers,
    John Esraelo

  • Screenshot 2022-09-02 123934

    Cheers,
    John Esraelo

  • Can you please post the full text of the error, as taken from the SSISDB All Executions report?

    Also from the All Executions report, on the 'Overview' page, check that the value of 'Caller' matches the account which should have access to the file.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • Thank you for the reply, Phil!

    It was a minor adjustment on the networking folks, and it is fixed now.

    thx

     

     

    Cheers,
    John Esraelo

  • John Esraelo-498130 wrote:

    Thank you for the reply, Phil!

    It was a minor adjustment on the networking folks, and it is fixed now.

    thx

    Two way street here... what was that "minor adjustment"?

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

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

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