Aug-11-2018, 10:31 PM
Hello Team
I'm new to python - here is my problem , any suggestions are welcome ..
We are using pentaho as a ETL tool to load data from CSV to SQL Server. Using python , I'm calling pentaho job in python , which will load data from CSV to SQL Server tables, this is working fine when I call python program using Windows command prompt.
I want to automate this process - I'm using window 10 task scheduler , but when it's running python program , it shows error that the path is not correct ..this path to get the csv file from a location
..any suggestion..how to do I test this ..because it's running in Command prompt assume it should work good in task schedular..pls suggest me the ways to debug.
Thanks
I'm new to python - here is my problem , any suggestions are welcome ..
We are using pentaho as a ETL tool to load data from CSV to SQL Server. Using python , I'm calling pentaho job in python , which will load data from CSV to SQL Server tables, this is working fine when I call python program using Windows command prompt.
I want to automate this process - I'm using window 10 task scheduler , but when it's running python program , it shows error that the path is not correct ..this path to get the csv file from a location
..any suggestion..how to do I test this ..because it's running in Command prompt assume it should work good in task schedular..pls suggest me the ways to debug.
Thanks