SQL Server Agent Run Python Script Issue

Question

I can run basic Python scripts from SQL Server Agent using the CmdExec to run a bat file pointing to my py file that prints hello world. However when trying run a file that uses the pandas module the Agent keeps coming up with the error below:

import pandas as pd File "C:\...\Python\Python39\lib\site-packages\pandas\__init__.py"<c/> line 47<c/> in <module> raise ImportError( ImportError: Unable to import required dependencies: dateutil: No module named 'dateutil'. Process Exit Code 1

The test code I am trying to execute is below:

import pandas as pd

lst=['a','b','c']

df=pd.DataFrame(lst)
df.to_csv(r'C:\Test.csv',index=False)

Seeing if you had any suggestions?

Jeff Schaller · Accepted Answer · 2024-02-15 19:02:18Z

0

Try pip install python-dateutil

edited Feb 15, 2024 at 19:02

Jeff Schaller

2,6969 gold badges29 silver badges45 bronze badges

answered Feb 15, 2024 at 6:46

Sneh Gurdasani

11 bronze badge

Sign up to request clarification or add additional context in comments.

4 Comments

greg_p Over a year ago

Thanks I gave that a shot but looks like I already had it installed.

siggemannen Over a year ago

You probably need to install it for the user running sql server agent, or globally.

greg_p Over a year ago

I am running the server agent on my local machine for testing and given the agent access to all folders. Not sure if that is what you mean.

greg_p Over a year ago

Checking if anyone had any possible solution?

Collectives™ on Stack Overflow

SQL Server Agent Run Python Script Issue

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related