when check directory at shared path remotely it display not exist (false) althou

Question

Post reply

when check directory at shared path remotely it display not exist (false) althou

ahmed_elbarbary.2010

Hall of Fame

Points: 3118
More actions
August 5, 2022 at 10:28 pm

#4073181
when check directory at shared path remotely it display not exist (false) although it exists
I have shared path '\\192.168.7.9\Import\8' I face
issue when try to check this directory path exist or not .
when run script python on sql server 2019 it must
return true because directory path exist but my
issue is python script return false although directory exist .
script python
```
declare @ExportPath varchar(max)='\\192.168.7.9\Import\8'
EXEC sp_execute_external_script
@language =N'Python',
@script=N'
import os
d = os.path.isdir(ExportFilePath)
print(d)'
,@params = N'@ExportFilePath NVARCHAR(MAX)'
,@ExportFilePath = @ExportPath
```
Expected result is True

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

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

Jeff Moden SSC Guru Points: 1003863 More actions · Answer 1

Aren't you missing a backslash at the end of the declaration for the @ExportPath?

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

ahmed_elbarbary.2010 Hall of Fame Points: 3118 More actions · Answer 2

i found issue

os.path.isdir() working local only

so use another thing working remote to check directory

so How to handle that

frederico_fonseca SSCoach Points: 16014 More actions · Answer 3

had you google it you would have found it - its amazing the type of information you get if you search for it instead of waiting for someone to give it to you.

it also shows a lack of consideration for the others to always expect them to do your work.

https://stackoverflow.com/questions/21701652/check-the-existence-of-file-on-local-network-in-python

Jeff Moden SSC Guru Points: 1003863 More actions · Answer 4

ahmed_elbarbary.2010 wrote:

i found issue
os.path.isdir() working local only
so use another thing working remote to check directory
so How to handle that

I don't use Python and I don't have 2019, so I can't help but this will "bump" your question for you because I'm also interested in how this would be done in Python.

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