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